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 <htamf...@gmail.com> a écrit : > On Tue, Feb 18, 2025 at 9:17 AM Sébastien <bokan...@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 > > -- > Crunchy Data - https://www.crunchydata.com > Enterprise Postgres Software Products & Tech Support > > -- Sébastien Caunes +33 6 7 229 229 7
