Re: Journal based VACUUM FULL

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: Journal based VACUUM FULL
Дата
Msg-id 20190222191557.cytzlfqmw5foqljq@alap3.anarazel.de
обсуждение исходный текст
Ответ на Re: Journal based VACUUM FULL  (Andreas Karlsson <andreas@proxel.se>)
Ответы Re: Journal based VACUUM FULL  (Andrew Dunstan <andrew.dunstan@2ndquadrant.com>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: libpq debug log
Следующее
От: Euler Taveira
Дата:
Сообщение: Re: Temporal Table Proposal