Postgres Pro
Downloads
Home   >   mailing lists

Re: [Feature Request] INSERT FROZEN to Optimize Large Cold Data Imports and Migrations - Mailing list pgsql-hackers

From Sébastien
Subject Re: [Feature Request] INSERT FROZEN to Optimize Large Cold Data Imports and Migrations
Date
Msg-id CANtq+vQUN=HVTFxYE4jeG2FKTxTvKcMjmyCtZ_0Vrdbh38ZqbA@mail.gmail.com
Whole thread Raw
In response to Re: [Feature Request] INSERT FROZEN to Optimize Large Cold Data Imports and Migrations  (Greg Sabino Mullane <htamfids@gmail.com>)
List pgsql-hackers
Tree view
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 by date:

Previous
From: Fujii Masao
Date:
Subject: Re: Extend postgres_fdw_get_connections to return remote backend pid
Next
From: "Devulapalli, Raghuveer"
Date:
Subject: RE: Improve CRC32C performance on SSE4.2