Skip site navigation (1) Skip section navigation (2)

Re: 8.2 Autovacuum BUG ?

From: Mark Lewis <mark(dot)lewis(at)mir3(dot)com>
To: Pallav Kalva <pkalva(at)livedatagroup(dot)com>
Cc: Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-performance(at)postgresql(dot)org
Subject: Re: 8.2 Autovacuum BUG ?
Date: 2007-08-31 16:29:31
Message-ID: 1188577771.22730.238.camel@archimedes (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
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.

In response to


pgsql-performance by date

Next:From: Chris BrowneDate: 2007-08-31 17:46:09
Subject: Re: 8.2 Autovacuum BUG ?
Previous:From: Pallav KalvaDate: 2007-08-31 16:25:16
Subject: Re: 8.2 Autovacuum BUG ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group