Re: Shared_buffers hint
| От | Marcelo Martins |
|---|---|
| Тема | Re: Shared_buffers hint |
| Дата | |
| Msg-id | 1538D014-0A5A-4DC1-928A-446E8A783267@zeroaccess.org обсуждение исходный текст |
| Ответ на | Shared_buffers hint ("Rafael Domiciano" <rafael.domiciano@gmail.com>) |
| Ответы |
About pg_hba.conf
|
| Список | pgsql-admin |
Hi Rafael,
The result there means that the minimal should be 4.69Mb for shared_buffers
As a rule of thumb the shared buffers should be between 10% - 15% of available RAM that assuming such is a dedicated PG server.
I have worked on some servers where I set shared buffers lower than 10%, it's really a matter of trying out what value works best for you.
On Oct 6, 2008, at 6:52 AM, Rafael Domiciano wrote:
HI people,I'm tuning a server that is a long time abandoned, and this server is a little slow.Now, in my postgresql.conf I have:shared_buffers = 100Mbmas_fsm_relations = 15000mas_fsm_pages = 1600000max_connections = 300And I changin' to:shared_buffers = 1000Mb(The server has 2 Gb of memory)mas_fsm_relations = 15000(The Vacuum noticed me 608 relations)mas_fsm_pages = 1600000(The Vacuum noticed me 500800 pages)max_connections = 300(I did a "ps axf | grep postgres | wc -l" and the bash brings to me the number of 120 and all the people is not online at now)My qustion is about shared_buffers, in postgresql.conf I have: min 128kB or max_connections*16kB # (change requires restart)So I did:300 * (16Kb / 1024) = 4,69?What this result means?Thnks all,Rafael Domiciano
В списке pgsql-admin по дате отправления: