Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Fri, 31 Aug 2007 09:29:31 -0700
- Message-id: <1188577771.22730.238.camel@archimedes> <text/plain>
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.
- Follow-Ups:
- Re: 8.2 Autovacuum BUG ?
- From: Pallav Kalva
- Re: 8.2 Autovacuum BUG ?
- References:
- 8.2 Autovacuum BUG ?
- From: Pallav Kalva
- Re: 8.2 Autovacuum BUG ?
- From: Tom Lane
- Re: 8.2 Autovacuum BUG ?
- From: Pallav Kalva
- Re: 8.2 Autovacuum BUG ?
- From: Alvaro Herrera
- Re: 8.2 Autovacuum BUG ?
- From: Pallav Kalva
- 8.2 Autovacuum BUG ?
- Prev by Date: Re: 8.2 Autovacuum BUG ?
- Next by Date: Re: 8.2 Autovacuum BUG ?
- Previous by thread: Re: 8.2 Autovacuum BUG ?
- Next by thread: Re: 8.2 Autovacuum BUG ?
- Indexes: