From: Mark Lewis <mark.lewis@mir3.com>
To: Pallav Kalva <pkalva@livedatagroup.com>
Cc: Alvaro Herrera <alvherre@commandprompt.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-performance@postgresql.org
Subject: Re: 8.2 Autovacuum BUG ?
Date: Fri, 31 Aug 2007 09:29:31 -0700
Message-ID: <1188577771.22730.238.camel@archimedes> (raw)
In-Reply-To: <46D840EC.1060302@livedatagroup.com>
References: <46D83427.60001@livedatagroup.com>
<25038.1188574775@sss.pgh.pa.us>
<46D83C50.3040409@livedatagroup.com>
<20070831161158.GD8046@alvh.no-ip.org>
<46D840EC.1060302@livedatagroup.com>
On Fri, 2007-08-31 at 12:25 -0400, Pallav Kalva wrote:
> Can you please correct me if I am wrong, I want to understand how this
> works.
> Based on what you said, it will run autovacuum again when it passes 200M
> transactions, as SELECTS are transactions too and are going on these
> tables.
> But the next time when it runs autovacuum, it shouldnt freeze the tuples
> again as they are already frozen and wont generate lot of archive logs ?
> Or is this because of it ran autovacuum for the first time on this db ?
> just the first time it does this process ?
That is correct. The tuples are now frozen, which means that they will
not need to be frozen ever again unless you insert/update any records.
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: mark.lewis@mir3.com, pkalva@livedatagroup.com, alvherre@commandprompt.com, tgl@sss.pgh.pa.us
Subject: Re: 8.2 Autovacuum BUG ?
In-Reply-To: <1188577771.22730.238.camel@archimedes>
* 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