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.



---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
     subscribe-nomail command to [EMAIL PROTECTED] so that your
     message can get through to the mailing list cleanly

Reply via email to