Re: Visibility map, partial vacuums - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Visibility map, partial vacuums
Date
Msg-id 20081203135120.GF3968@alvh.no-ip.org
Whole thread Raw
In response to Re: Visibility map, partial vacuums  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
List pgsql-hackers
Heikki Linnakangas wrote:

> Hmm. It just occurred to me that I think this circumvented the  
> anti-wraparound vacuuming: a normal vacuum doesn't advance relfrozenxid  
> anymore. We'll need to disable the skipping when autovacuum is triggered  
> to prevent wraparound. VACUUM FREEZE does that already, but it's  
> unnecessarily aggressive in freezing.

Heh :-)  Yes, this should be handled sanely, without having to invoke
FREEZE.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support


pgsql-hackers by date:

Previous
From: Gregory Stark
Date:
Subject: Re: Visibility map, partial vacuums
Next
From: Magnus Hagander
Date:
Subject: Re: Visibility map, partial vacuums