Re: why there is not VACUUM FULL CONCURRENTLY?

Поиск
Список
Период
Сортировка
От Nathan Bossart
Тема Re: why there is not VACUUM FULL CONCURRENTLY?
Дата
Msg-id Z6Emm1Sj8Xz1hoFO@nathan
обсуждение исходный текст
Ответ на Re: why there is not VACUUM FULL CONCURRENTLY?  (Michael Banck <mbanck@gmx.net>)
Список pgsql-hackers
On Thu, Jan 30, 2025 at 04:29:35PM +0100, Alvaro Herrera wrote:
> A bunch of people discussed this patch in today's developer meeting in
> Brussels.  There's pretty much a consensus on using the verb REPACK
> CONCURRENTLY for this new command -- where unadorned REPACK would be
> VACUUM FULL, and we'd have something like REPACK WITH INDEX or maybe
> REPACK USING INDEX to take the CLUSTER place.

+1

One small thing I thought of after the meeting was that this effectively
forces users to always specify an index if they want to REPACK WITH INDEX.
Today, CLUSTER will use the same index as before if one is not specified.
IMHO requiring users to specify the index is entirely reasonable, but I
figured I'd at least note the behavior change.

-- 
nathan



В списке pgsql-hackers по дате отправления: