Re: point in time recovery and moving datafiles online - Mailing list pgsql-hackers

From Tom Lane
Subject Re: point in time recovery and moving datafiles online
Date
Msg-id 17273.1014394464@sss.pgh.pa.us
Whole thread Raw
In response to point in time recovery and moving datafiles online  (Marc Munro <marc@bloodnok.com>)
List pgsql-hackers
"Zeugswetter Andreas SB SD" <ZeugswetterA@spardat.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


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Replication direction
Next
From: Bruce Momjian
Date:
Subject: Re: CLUSTER TODO item