Re: point in time recovery and moving datafiles online

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Zeugswetter Andreas SB SD" <ZeugswetterA(at)spardat(dot)at>
Cc: "Marc Munro" <marc(at)bloodnok(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: point in time recovery and moving datafiles online
Date: 2002-02-22 16:14:24
Message-ID: 17273.1014394464@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Zeugswetter Andreas SB SD" <ZeugswetterA(at)spardat(dot)at> writes:
>> I do believe that vacuum should (but presently does not) emit a WAL
>> record showing its truncation of the file, so that the equivalent
>> truncation can be repeated during replay.

> I see, but it has only the effect of not freeing the space to the OS,
> so it is not really a bug ? Next vacuum will do it anyway.

[ thinks... ] Yeah, you're probably right. The extra pages should
contain only dead tuples (either already dead or moved-off by vacuum),
so a seqscan would find no live data in them anyway. It should be
fixed, but it's not critical (except possibly for people who are low
on disk space...)

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2002-02-22 16:15:11 Re: CLUSTER TODO item
Previous Message Bruce Momjian 2002-02-22 16:12:56 Re: Automatic transactions in psql