Re: Shared Buffer setting in postgresql.conf
От
Scott Marlowe
Тема
Re: Shared Buffer setting in postgresql.conf
Дата
Msg-id
dcc563d10710101749k12d58355q721cc9b741eaa6cc@mail.gmail.com
Ответ на
Re: Shared Buffer setting in postgresql.conf (Radhika S)
Список
Дерево обсуждения
Shared Buffer setting in postgresql.conf "Radhika S" <radhika.sambamurti@gmail.com>
Re: Shared Buffer setting in postgresql.conf "Marcin Stępnicki" <mstepnicki@gmail.com>
Re: Shared Buffer setting in postgresql.conf "Scott Marlowe" <scott.marlowe@gmail.com>
Re: Shared Buffer setting in postgresql.conf Josh Trutwin <josh@trutwins.homeip.net>
Re: Shared Buffer setting in postgresql.conf "Scott Marlowe" <scott.marlowe@gmail.com>
Re: Shared Buffer setting in postgresql.conf "Radhika S" <radhika.sambamurti@gmail.com>
Re: Shared Buffer setting in postgresql.conf "Scott Marlowe" <scott.marlowe@gmail.com>
Re: Shared Buffer setting in postgresql.conf Ow Mun Heng <Ow.Mun.Heng@wdc.com>
On 10/10/07, Radhika S wrote: > Thank you scott. > > We plan on upgrading to Postgres 8.2 very soon. > Would it be safe to say I can make my SHARED BUFFER setting 200MB (I have > 2GB memory ). > The default is 24MB. On a dedicated db machine with 2 Gigs of ram 500Meg is fine. I run 768 Meg shared_buffers on a machine that runs postgresql 8.2 and apache/php and routinely have 1Gig of kernel cache on it. So yeah, 200M shared_buffers should be no problem.
В списке pgsql-performance по дате отправления
