From: Ragnar <gnari@hive.is>
To: ALVARO ARCILA <arcila_alvaro@hotmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: max_fsm_pages and check_points
Date: Wed, 20 Dec 2006 09:01:28 +0000
Message-ID: <1166605288.6369.274.camel@localhost.localdomain> (raw)
In-Reply-To: <BAY121-W16DAEF170C0B7B617356B083CF0@phx.gbl>
References: <BAY121-W16DAEF170C0B7B617356B083CF0@phx.gbl>
On mið, 2006-12-20 at 05:31 +0000, ALVARO ARCILA wrote:
>
> HI,
>
> I've looking around the log files of my server and lately they
> indicate that I should consider increase the check_point segments
> because they're beeing reading too often and also recommend increasing
> the max_fsm_pages over 169728...
if this has been happening for some time, some tables
might possibly have become bloated with dead rows, so
a one-time VACUUM FULL or CLUSTER on these might be indicated
to speed up reaching the steady state.
I think the max_fsm_pages is a minimum recommendation, so you
might want to look at VACUUM VERBOSE output after setting it,
to see if an even higher value is indicated
> those are the config values present in the postgresql.conf
>
> shared_buffers = 1000
> work_mem = 8192
if you have got a lot of memory, you might want to experiment
with these a little
gnari
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-performance@postgresql.org
Cc: gnari@hive.is, arcila_alvaro@hotmail.com
Subject: Re: max_fsm_pages and check_points
In-Reply-To: <1166605288.6369.274.camel@localhost.localdomain>
* 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