From: Adam Tauno Williams <adamtaunowilliams@gmail.com>
To: pgsql-performance@postgresql.org
Subject: Re: Shared memory usage
Date: Mon, 27 Aug 2007 06:21:43 -0400
Message-ID: <1188210103.4723.4.camel@aleph.wmmi.net> (raw)
In-Reply-To: <op.txmwckj4ll0p5y@1-rtt202dnf3uds.mshome.net>
References: <op.txmwckj4ll0p5y@1-rtt202dnf3uds.mshome.net>
> 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, but do not use the shared memory.
> shared_buffers is set to 60000, yet they use a minimal part of that. I'd
> like to know why won't they use more?
This just looks like the output of top; what is telling you that
PostgreSQL is not using the shared memory? Enable statistics collection
and then look in pg_statio_user_tables.
> top - 00:12:35 up 50 days, 13:22, 8 users, load average: 4.84, 9.71,
> 13.22
> Tasks: 279 total, 10 running, 268 sleeping, 1 stopped, 0 zombie
> Cpu(s): 50.0% us, 12.9% sy, 0.0% ni, 33.2% id, 1.8% wa, 0.0% hi, 2.1%
> si
> Mem: 6102304k total, 4206948k used, 1895356k free, 159436k buffers
> Swap: 1959888k total, 12304k used, 1947584k free, 2919816k cached
> PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
> 11492 postgres 16 0 530m 72m 60m S 14 1.2 0:50.91 postmaster
> 11493 postgres 16 0 531m 72m 60m R 14 1.2 0:48.78 postmaster
> 11490 postgres 15 0 530m 71m 59m S 13 1.2 0:50.26 postmaster
> 11491 postgres 15 0 531m 75m 62m S 11 1.3 0:50.67 postmaster
> 11495 postgres 16 0 530m 71m 59m R 10 1.2 0:50.71 postmaster
> 10195 postgres 15 0 536m 84m 66m S 6 1.4 1:11.72 postmaster
--
Adam Tauno Williams, Network & Systems Administrator
Consultant - http://www.whitemiceconsulting.com
Developer - http://www.opengroupware.org
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: adamtaunowilliams@gmail.com
Subject: Re: Shared memory usage
In-Reply-To: <1188210103.4723.4.camel@aleph.wmmi.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox