Re: Journal based VACUUM FULL

From: Andres Freund <andres(at)anarazel(dot)de>
To: Andreas Karlsson <andreas(at)proxel(dot)se>
Cc: Ryan David Sheasby <ryan27968(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Journal based VACUUM FULL
Date: 2019-02-22 19:15:57
Message-ID: 20190222191557.cytzlfqmw5foqljq@alap3.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Euler Taveira 2019-02-22 19:31:25 Re: Temporal Table Proposal
Previous Message Tom Lane 2019-02-22 18:51:56 Re: libpq debug log