Re: [PERFORM] Performance problems with a higher number of clients

Thanks for the advices, The performance is a bit better now. Unfortunately, the machine does not allow to put more than 200 - ~250 users without noticing swap hell. I have to face the fact that I don't have enough memory I used the following configuration: effective_cache_size = 65000 share

Re: [PERFORM] Performance problems with a higher number of clients

Alfranio Correia Junior <[EMAIL PROTECTED]> writes: > I am facing a problem trying to put 500 concurrent users accessing > a postgresql instance. I think you're going to need to buy more RAM. 1Gb of RAM means there is a maximum of 2Mb available per Postgres process before you start to go into swa

Re: [PERFORM] Performance problems with a higher number of clients

On Thu, 11 Dec 2003 04:13:28 + Alfranio Correia Junior <[EMAIL PROTECTED]> wrote: > r b w swpd free buff cache si sobibo incs > us sy id > 2 29 1 106716 9576 7000 409876 32 154 5888 1262 616 1575 > 8 12 80 On linux I've found as soon as it has t

Re: [PERFORM] 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