Re: Shared memory usage
От
Max Zorloff
Тема
Re: Shared memory usage
Дата
Msg-id
op.txpy8trnll0p5y@1-rtt202dnf3uds.mshome.net
Ответ на
Re: Shared memory usage (Adam Tauno Williams)
Список
Дерево обсуждения
Shared memory usage "Max Zorloff" <zorloff@gmail.com>
Re: Shared memory usage Adam Tauno Williams <adamtaunowilliams@gmail.com>
Re: Shared memory usage "Max Zorloff" <zorloff@gmail.com>
Re: [GENERAL] Shared memory usage Martijn van Oosterhout <kleptog@svana.org>
Re: [GENERAL] Shared memory usage "Max Zorloff" <zorloff@gmail.com>
Re: [GENERAL] Shared memory usage "Max Zorloff" <zorloff@gmail.com>
Re: Shared memory usage Greg Smith <gsmith@gregsmith.com>
Re: Shared memory usage "Max Zorloff" <zorloff@gmail.com>
On Mon, 27 Aug 2007 14:21:43 +0400, Adam Tauno Williams 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 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. I have it enabled. How can I tell whether the shared memory is used from the information in this table?
В списке pgsql-performance по дате отправления
