From: Scott Carey <scott@richrelevance.com>
To: Kevin Grittner <Kevin.Grittner@wicourts.gov>
Cc: Scott Marlowe <scott.marlowe@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: alvherre@commandprompt.com, duanlg@nec-as.nec.com.cn, pgsql-performance@postgresql.org, "Matt Smiley" <mss@rentrak.com>
Subject: Re: too many clog files
Date: Wed, 10 Sep 2008 10:55:26 -0700
Message-ID: <a1ec7d000809101055m54f27647l4e546ec87e14f4c7@mail.gmail.com> (raw)
In-Reply-To: <48C7C1FA.EE98.0025.0@wicourts.gov>
References: <48C5CC04.D078.0028.0@rentrak.com>
<48C6F7A5.D078.0028.0@rentrak.com>
<48C79A55.EE98.0025.0@wicourts.gov>
<dcc563d10809101018u1f77199bpcc134121d7d040ad@mail.gmail.com>
<2257.1221068560@sss.pgh.pa.us>
<48C7C1FA.EE98.0025.0@wicourts.gov>
And potentially to tune down the number kept by modifying the appropriate
freeze parameter for 8.1 (I'm not sure of the details), so that it keeps
perhaps 20MB or so rather than 50MB.
On Wed, Sep 10, 2008 at 10:47 AM, Kevin Grittner <
Kevin.Grittner@wicourts.gov> wrote:
> >>> Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> > The expected behavior (in 8.2 and newer) is to maintain about
> > autovacuum_freeze_max_age transactions' worth of clog; which is to
> say
> > about 50MB at the default settings.
>
> The active database I checked, where it didn't go all the way back to
> 0000, had 50 MB of files; so I guess it is working as intended.
>
> It sounds like the advice to the OP that running VACUUM FREEZE on all
> databases to clean up the files was off base?
>
> -Kevin
>
> --
> Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>
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: scott@richrelevance.com, Kevin.Grittner@wicourts.gov, scott.marlowe@gmail.com, tgl@sss.pgh.pa.us, mss@rentrak.com
Subject: Re: too many clog files
In-Reply-To: <a1ec7d000809101055m54f27647l4e546ec87e14f4c7@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