uld be
more appropriate, and I'm only replying to there.
Sorry, didn't know that.
On Sun, 26 Aug 2007, Max Zorloff wrote:
shared_buffers is set to 6, yet they use a minimal part of that.
PID USER PR NI VIRT RES SHR S %CPU %MEMTIME+ COMMAND
11492 postgres 16 0
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
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 need
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 syste
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,
