Re: Visibility map, partial vacuums

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: Visibility map, partial vacuums
Date: 2008-12-03 13:51:20
Message-ID: 20081203135120.GF3968@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Magnus Hagander 2008-12-03 13:56:14 Re: Re: [BUGS] libpq does not manage SSL callbacks properly when other libraries are involved.
Previous Message ohp 2008-12-03 13:13:01 Re: cvs head initdb hangs on unixware