From: Andres Freund <andres@anarazel.de>
To: Florian Weimer <fweimer@bfk.de>
Cc: pgsql-performance@postgresql.org
Subject: Re: Wrong docs on checkpoint_segments?
Date: Fri, 7 Jan 2011 14:47:24 +0100
Message-ID: <201101071447.24345.andres@anarazel.de> (raw)
In-Reply-To: <82mxnceskh.fsf@mid.bfk.de>
References: <82aajcg9wa.fsf@mid.bfk.de>
<201101071439.32053.andres@anarazel.de>
<82mxnceskh.fsf@mid.bfk.de>
On Friday, January 07, 2011 02:45:02 PM Florian Weimer wrote:
> * Andres Freund:
> > On Friday, January 07, 2011 01:45:25 PM Florian Weimer wrote:
> >> On 9.0, this configuration
> >>
> >> checkpoint_segments = 512 # in logfile segments, min 1, 16MB each
> >>
> >> results in 1034 segments, so the effective logfile segment size is 32
> >> MB.
> >
> > Um. Is it possible that you redefined XLOG_SEG_SIZE or used --with-wal-
> > segsize=SEGSIZE?
>
> No, the individual files are still 16 MB. It's just that the
> checkpoint_segments limit is not a hard limit, and you end up with
> slightly more than twice the configured number of segments on disk.
Thats documented:
"
There will always be at least one WAL segment file, and will normally not be
more files than the higher of wal_keep_segments or (2 +
checkpoint_completion_target) * checkpoint_segments + 1. Each segment file is
normally 16 MB (though this size can be altered when building the server). You
can use this to estimate space requirements for WAL. Ordinarily, when old log
segment files are no longer needed, they are recycled (renamed to become the
next segments in the numbered sequence). If, due to a short-term peak of log
output rate, there are more than 3 * checkpoint_segments + 1 segment files, the
unneeded segment files will be deleted instead of recycled until the system
gets back under this limit.
"
Andres
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: andres@anarazel.de, fweimer@bfk.de
Subject: Re: Wrong docs on checkpoint_segments?
In-Reply-To: <201101071447.24345.andres@anarazel.de>
* 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