Re: [PERFORM] Shared memory usage

2007-08-29 Thread Max Zorloff
On Wed, 29 Aug 2007 23:26:06 +0400, Greg Smith <[EMAIL PROTECTED]> wrote: First off, posting to two lists like you did (-general and -performance) is frowned on here. Pick whichever is more appropriate for the topic and post to just that one; in your case, the performance list would be m

Re: [PERFORM] Shared memory usage

2007-08-29 Thread Greg Smith
First off, posting to two lists like you did (-general and -performance) is frowned on here. Pick whichever is more appropriate for the topic and post to just that one; in your case, the performance list would be more appropriate, and I'm only replying to there. On Sun, 26 Aug 2007, Max Zorlo

Re: [PERFORM] Shared memory usage

2007-08-27 Thread Max Zorloff
On Mon, 27 Aug 2007 14:21:43 +0400, Adam Tauno Williams <[EMAIL PROTECTED]> wrote: 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 demo

Re: [PERFORM] Shared memory usage

2007-08-27 Thread Adam Tauno Williams
> 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 running some insert/update tasks. I see > that they all use cpu heavil

[PERFORM] Shared memory usage

2007-08-25 Thread Max Zorloff
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 running some insert/update tasks. I see that they all use cpu heavily,