Re: [PERFORM] [GENERAL] Shared memory usage

2007-08-25 Thread Max Zorloff
On Sun, 26 Aug 2007 00:39:52 +0400, Martijn van Oosterhout <[EMAIL PROTECTED]> wrote: On Sun, Aug 26, 2007 at 01:22:58AM +0400, Max Zorloff wrote: Hello. shared_memory is used for caching. It is filled as stuff is used. If you're not using all of it that means it isn't needed. Remember, it

Re: [PERFORM] [GENERAL] Shared memory usage

2007-08-25 Thread Max Zorloff
On Sun, 26 Aug 2007 00:39:52 +0400, Martijn van Oosterhout <[EMAIL PROTECTED]> wrote: On Sun, Aug 26, 2007 at 01:22:58AM +0400, Max Zorloff wrote: Hello. I have a postgres 8.0 and ~400mb database with lots of simple selects using indexes. I've installed pgpool on the system. I've set num_ini

Re: [PERFORM] [GENERAL] Shared memory usage

2007-08-25 Thread Martijn van Oosterhout
On Sun, Aug 26, 2007 at 01:22:58AM +0400, Max Zorloff wrote: > Hello. > > I have a postgres 8.0 and ~400mb database with lots of simple selects > using indexes. > I've installed pgpool on the system. I've set num_init_children to 5 and > here is the top output. > One of postmasters is my demon