From: Rafael Domiciano <rafael.domiciano@gmail.com>
To: Scott Marlowe <scott.marlowe@gmail.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Shared_buffers hint
Date: Mon, 6 Oct 2008 11:56:51 -0200
Message-ID: <3a0028490810060656o5d1482a0r1efdb594f3aeb16c@mail.gmail.com> (raw)
In-Reply-To: <dcc563d10810060642m175af9ddt7240e065b1b6d53@mail.gmail.com>
References: <3a0028490810060452m268d0777uc18e2e605ff0bd28@mail.gmail.com>
<dcc563d10810060642m175af9ddt7240e065b1b6d53@mail.gmail.com>
I'm using 8.3.3 version in this machine..!So, the shared_buffers set to
100Mb is ok? Or 500Mb is better?
This server we call "Reporter Server", so it's used to do heavy reports for
a few users only (I could say 5 users).
What could be the best config for my server with:
2 Gb RAM
300 GB HD
Postgres 8.3
Dual Core
2008/10/6 Scott Marlowe <scott.marlowe@gmail.com>
> On Mon, Oct 6, 2008 at 5:52 AM, Rafael Domiciano
> <rafael.domiciano@gmail.com> wrote:
> > HI people,
> > I'm tuning a server that is a long time abandoned, and this server is a
> > little slow.
>
> What version pgsql is it running? If it's 7.4 or before, you should
> look at upgrading it. If you can't then a shared buffer setting in
> the 1000 to 10000 range is generally reasonable, but large
> shared_buffer settings (i.e. over 10000) are counterproductive for 7.4
> and before.
>
> > Now, in my postgresql.conf I have:
> > shared_buffers = 100Mb
>
> So it's a pretty modern version, since old ones can't read 100Mb as a
> setting.
>
> > 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)
>
> 50% is kind of big. Generally you either want it small enough that
> the OS can do the majority of the caching (it's usually better at
> caching large amounts of data) or large enough that the kernel cache
> doesn't come into play much. 50% means that everything is buffered
> exactly twice.
>
> > 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?
>
> That's just the minimum the server needs to operate. Not operate
> well, just operate.
>
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, scott.marlowe@gmail.com
Subject: Re: Shared_buffers hint
In-Reply-To: <3a0028490810060656o5d1482a0r1efdb594f3aeb16c@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