Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: 8.2 Autovacuum BUG ?
- From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
- To: Pallav Kalva <pkalva(at)livedatagroup(dot)com>
- Cc: pgsql-performance(at)postgresql(dot)org, Mark Lewis <mark(dot)lewis(at)mir3(dot)com>
- Subject: Re: 8.2 Autovacuum BUG ?
- Date: Fri, 31 Aug 2007 14:51:28 -0400
- Message-id: <20070831185128.GM8046@alvh.no-ip.org> <text/plain>
Pallav Kalva wrote: > My main concern is filling up my disk with archive logs, so from all the > replies I get is that since tuples are already frozen, next time when it > runs autovacuum it wont generate any archive logs. > > Is my assumption right ? Well, it won't generate any logs for the tuples that were just frozen, but it will generate logs for tuples that weren't frozen. How many of these there are, depends on how many tuples you inserted after the batch that was just frozen. If you want to freeze the whole table completely, you can you VACUUM FREEZE. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support
- 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
- Re: 8.2 Autovacuum BUG ?
- From: Mark Lewis
- 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: