From: Matthew T. O'Connor <matthew@zeut.net>
To: Tom Lane <tgl@sss.pgh.pa.us>
To: Benjamin Krajmalnik <kraj@illumen.com>
To: pgsql-admin@postgresql.org, "Matthew T. O'Connor" <matthew@zeut.net>
Subject: Re: pg_clog questions
Date: Thu, 25 May 2006 22:20:46 -0400
Message-ID: <447665FE.5010905@zeut.net> (raw)
In-Reply-To: <20060525204319.GL13700@surnet.cl>
References: <8511B4970E0D124898E973DF496F9B432516E3@stash.stackdump.local>
<15596.1148588444@sss.pgh.pa.us>
<20060525204319.GL13700@surnet.cl>
Alvaro Herrera wrote:
> Tom Lane wrote:
>> Hm. I believe that autovac only does database-wide vacuums when it
>> thinks they're necessary to prevent transaction wraparound failures.
>> Which would mean that it'd let pg_clog grow to something on the order
>> of half a gig before any truncation would happen. That's probably
>> insufficiently aggressive :-(
>>
>> Alvaro, Matthew, any thoughts about improving that?
Not really. Alvara mentioned reducing the constant that we test against
for DB wide vacuum. I'm a little concerned that might result is
database-wide vacuums more often than desired, but I don't see a better
answer off the top of my head.
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: matthew@zeut.net, tgl@sss.pgh.pa.us, kraj@illumen.com
Subject: Re: pg_clog questions
In-Reply-To: <447665FE.5010905@zeut.net>
References: <8511B4970E0D124898E973DF496F9B432516E3@stash.stackdump.local> <15596.1148588444@sss.pgh.pa.us> <20060525204319.GL13700@surnet.cl> <447665FE.5010905@zeut.net>
* 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