Re: Incomplete freezing when truncating a relation during vacuum - Mailing list pgsql-hackers

From Andres Freund
Subject Re: Incomplete freezing when truncating a relation during vacuum
Date
Msg-id 09263396-0d78-4eb6-99f9-7fe74ea2bbfe@email.android.com
Whole thread Raw
In response to Re: Incomplete freezing when truncating a relation during vacuum  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Incomplete freezing when truncating a relation during vacuum
List pgsql-hackers

Tom Lane <tgl@sss.pgh.pa.us> schrieb:
>Andres Freund <andres@2ndquadrant.com> writes:
>> The VACUUM implementation in 9.3 had several bugs: It removed
>multixact
>> xmax values without regard of the importance of contained xids, it
>did
>> not remove multixacts if the contained xids were too old and it
>relied
>> on hint bits when checking whether a row needed to be frozen which
>might
>> not have been set on replicas.
>
>Uh ... what does the last have to do with it?  Surely we don't run
>VACUUM on replicas.  Or are you talking about what might happen when
>VACUUM is run on a former replica that's been promoted to master?

Unfortunately not. The problem is that xl_heap_freeze's redo function simply reexecutes heap-freeze-tuple() instead of
loggingmuch about each tuple...
 

Andres


-- 
Please excuse brevity and formatting - I am writing this on my mobile phone.

Andres Freund                       http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Incomplete freezing when truncating a relation during vacuum
Next
From: Jeff Janes
Date:
Subject: Re: Handling GIN incomplete splits