Re: [GENERAL] Need for help!

2008-05-15 Thread Semi Noob
" and "effective_cache_size". Thank you once more! Regards, Semi Noob 2008/5/15 Pavan Deolasee <[EMAIL PROTECTED]>: > On Tue, May 13, 2008 at 2:43 PM, Semi Noob <[EMAIL PROTECTED]> wrote: > > But after upgrade the max clients is > > also 64 (?!?) Is this t

[GENERAL] Need for help!

2008-05-15 Thread Semi Noob
Dear all, I have a postgres 8.2.5 and ~6 GB database with lots of simple selects using indexes. I see that they use the shared memory so much. Before, my server has 4GB of RAM, shmmax 1GB, Shared_buffers is set to 256 MB, effective_cache_size 300MB, when i test it's performance with option -c 40 -t