Re: Forward zeroing of pg_clog

From: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Forward zeroing of pg_clog
Date: 2004-09-01 14:59:56
Message-ID: 20040901145956.GD5798@dcc.uchile.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Aug 30, 2004 at 02:19:49PM -0400, Tom Lane wrote:

> This particular issue is just a simple oversight in xact_redo, and it's
> easily fixed: make sure nextXID gets advanced past all of the committed
> or aborted subXIDs too.

Certainly this is the right thing to do.

> [...] but I think the cleanest fix is that the clog code ought to
> forcibly zero all clog entries ahead of whatever nextXID is settled on
> by WAL replay.

I agree with this too.

Thanks for taking care of all this stuff.

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"We are who we choose to be", sang the goldfinch
when the sun is high (Sandman)

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message G u i d o B a r o s i o 2004-09-01 15:07:39 Re: slower every day
Previous Message Jan Wieck 2004-09-01 14:41:42 Re: version upgrade