Re: [Feature Request] INSERT FROZEN to Optimize Large Cold Data Imports and Migrations

Поиск
Список
Период
Сортировка
От Sébastien
Тема Re: [Feature Request] INSERT FROZEN to Optimize Large Cold Data Imports and Migrations
Дата
Msg-id CANtq+vQUN=HVTFxYE4jeG2FKTxTvKcMjmyCtZ_0Vrdbh38ZqbA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [Feature Request] INSERT FROZEN to Optimize Large Cold Data Imports and Migrations  (Greg Sabino Mullane <htamfids@gmail.com>)
Список pgsql-hackers
Дерево обсуждения
Ok you mean that xid64 will remove the need for freezing... it's a way to see things.

Le mar. 18 févr. 2025 à 15:57, Greg Sabino Mullane <htamfids@gmail.com> a écrit :
On Tue, Feb 18, 2025 at 9:17 AM Sébastien <bokanist@gmail.com> wrote:
Sorry it won't work. It just delays the problem. But still the freeze procedure must rewrite all pages.

Actually, a 64-bit transaction ID allows for quite a "delay" - like hundreds of millions of years at your current rate. :) 

(Yes, there are other reasons to vacuum, and other limits and problems would arise. You'd have 99 problems, but a vacuum freeze ain't one.)

Cheers,
Greg

--
Enterprise Postgres Software Products & Tech Support



--
Sébastien Caunes
+33 6 7 229 229 7

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