PostgreSQL performance tuning

Concluído Postado Aug 10, 2009 Pago na entrega
Concluído Pago na entrega

**We need an expert who could make a fine tuning of a PostgreSQL database.**

## Deliverables

We have a data-intensive application with the following characteristics:

* 10 threads are concurrently inserting up to [url removed, login to view] rows each day into a single table.

* At the same time, 5 threads are concurrently selecting and updating the inserted rows.

* Finally, a web application, allows 10 people to select an update 100.000 records of the same table a day.

We have the PostgreSQL database with its default configuration and the queries run really slow. Queries regarding “select count??, “order by?? and “updates?? are the worst. We have created some indexes for the main tables but the performance is still too low and it seems to be a configuration issue.

We just need you to access our DB for tuning the configuration and documenting the changes.

We have the Postgres in the Amazon cloud with the following configuration:

•? 7.5 GB memory

•? 2 virtual cores

•? 850 GB instance storage (2?-420 GB plus 10 GB root partition)

•? 64-bit platform

•? PostgreSQL 8.3

•? No other application running on the same server

We can send you more detail about the queries we are used to doing.

Administração de Bancos de Dados Linux MySQL SQL

ID do Projeto: #2830828

Sobre o projeto

2 propostas Projeto remoto Ativo em Aug 24, 2009

Concedido a:

ludikatech

See private message.

$34 USD em 14 dias
(28 Comentários)
3.7

2 freelancers estão ofertando em média $28 nesse trabalho

tomuffner

See private message.

$21.25 USD in 14 dias
(11 Comentários)
3.4
fizzl

See private message.

$68 USD in 14 dias
(0 Comentários)
1.9