Re: Journal based VACUUM FULL - Mailing list pgsql-hackers

From Andres Freund
Subject Re: Journal based VACUUM FULL
Date
Msg-id 20190222191557.cytzlfqmw5foqljq@alap3.anarazel.de
Whole thread Raw
In response to Re: Journal based VACUUM FULL  (Andreas Karlsson <andreas@proxel.se>)
Responses Re: Journal based VACUUM FULL
List pgsql-hackers
Hi,

On 2019-02-21 16:27:06 +0100, Andreas Karlsson wrote:
> I have not heard many requests for bringing back the old behavior, but I
> could easily have missed them. Either way I do not think there would be much
> demand for an in-place VACUUM FULL unless the index bloat problem is also
> solved.

Yea, I don't think there's much either. What I think there's PLENTY need
for is something like pg_repack in core.  And could argue that the
trigger based logging it does to catch up to changes made concurrently
with the rewrite, to the old table, is a form of journaling...

Greetings,

Andres Freund


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: libpq debug log
Next
From: Euler Taveira
Date:
Subject: Re: Temporal Table Proposal