Re: Performance problems with a higher number of clients

From: Shridhar Daithankar <shridhar_daithankar(at)myrealbox(dot)com>
To: Alfranio Correia Junior <alfranio(at)lsd(dot)di(dot)uminho(dot)pt>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Performance problems with a higher number of clients
Date: 2003-12-11 06:36:23
Message-ID: 3FD81067.6010305@myrealbox.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Jeff 2003-12-11 13:28:26 Re: Performance problems with a higher number of clients
Previous Message Mark Kirkwood 2003-12-11 06:09:47 Re: Solaris Performance (Again)