Re: Forward zeroing of pg_clog

From: "Simon Riggs" <simon(at)2ndquadrant(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Alvaro Herrera" <alvherre(at)dcc(dot)uchile(dot)cl>
Cc: <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Re: Forward zeroing of pg_clog
Date: 2004-09-01 07:30:11
Message-ID: NOEFLCFHBPDAFHEIPGBOAEKLCDAA.simon@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> Tom Lane wrote

> This is already true at the page level: when advancing into a new page
> we zero it instead of reading anything from disk. I am thinking of
> adding code to StartupCLOG to zero the remaining portion of the
> "current" page too.
>
> Thoughts?
>

That sounds like the right thing to do. IIRC that means we do it once at the
very end of recovery, which is quick as well as safe.

This is important for point-in-time recovery also, since there would always
be clog entries ahead of the recovery target.

Best Regards, Simon Riggs

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Fabien COELHO 2004-09-01 08:31:11 open item: tablespace handing in pg_dump/pg_restore
Previous Message Greg Stark 2004-09-01 06:35:00 Data point on the competition regarding selectivity of unknown parameters