Re: reloption to prevent VACUUM from truncating empty pages at theend of relation - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: reloption to prevent VACUUM from truncating empty pages at theend of relation
Date
Msg-id [email protected]
Whole thread Raw
In response to Re: reloption to prevent VACUUM from truncating empty pages at the end of relation  (Tom Lane <[email protected]>)
Responses Re: reloption to prevent VACUUM from truncating empty pages at the end of relation
List pgsql-hackers
On 2019-Feb-28, Tom Lane wrote:

> Alvaro Herrera <[email protected]> writes:
> > Hopefully we'll get Tom's patch that addresses the failure-to-truncate
> > issues in pg12.
> 
> Hm, are you speaking of the handwaving I did in
> https://www.postgresql.org/message-id/[email protected]
> ?
> 
> I wasn't really working on that for v12 --- I figured it was way
> too late in the cycle to be starting on such a significant change.

Oh, well, it certainly seems far too late *now*.  However, what about
the idea in 
https://postgr.es/m/[email protected]
namely that we write out the buffers involved?  That sounds like it
might be backpatchable, and thus it's not too late for it.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: some ri_triggers.c cleanup
Next
From: Tomas Vondra
Date:
Subject: Re: [HACKERS] PATCH: multivariate histograms and MCV lists