Re: Performance problems with a higher number of clients

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