Alfranio Correia Junior wrote:
> Postgresql configuration:
>
> effective_cache_size = 35000
> shared_buffers = 5000
> random_page_cost = 2
> cpu_index_tuple_cost = 0.0005
> sort_mem = 10240
Lower sort mem to say 2000-3000, up shared buffers to 10K and up effective cache
size to around 65K. That should make it behave bit better.
I guess tuning sort mem alone would give you performance you are expecting..
Tune them one by one.
HTH
Shridhar