From: Rafael Domiciano <rafael.domiciano@gmail.com>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Shared_buffers hint
Date: Mon, 6 Oct 2008 09:52:59 -0200
Message-ID: <3a0028490810060452m268d0777uc18e2e605ff0bd28@mail.gmail.com> (raw)
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 = 100Mb
mas_fsm_relations = 15000
mas_fsm_pages = 1600000
max_connections = 300
And 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
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-admin@postgresql.org
Cc: rafael.domiciano@gmail.com
Subject: Re: Shared_buffers hint
In-Reply-To: <3a0028490810060452m268d0777uc18e2e605ff0bd28@mail.gmail.com>
* 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