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

Re: Upgrading rant.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Lamar Owen <lamar(dot)owen(at)wgcr(dot)org>, Hannu Krosing <hannu(at)tm(dot)ee>,mlw <pgsql(at)mohawksoft(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Upgrading rant.
Date: 2003-01-06 03:30:41
Message-ID: 25058.1041823841@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> VACUUM FREEZE.  Interesting idea.  Did we have that in 7.2?  I never
> thought of using it.  Good idea.

IIRC, it was new in 7.2 --- but pg_upgrade goes back further than that.
I am not sure if this idea just escaped us before, or if there's a hole
in it.  We need to study it carefully.

> Why do we have to do WAL?  Do we have WAL log id's in the tuple headers?

Not in tuple headers, but in page headers.  The buffer manager will
choke if the LSN fields point past the end of WAL.

			regards, tom lane

In response to

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2003-01-06 03:36:01
Subject: Re: AclId is defined in the wrong place
Previous:From: Bruce MomjianDate: 2003-01-06 03:25:21
Subject: Re: Upgrading rant.

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