Postgres Pro
Downloads
Home   >   mailing lists

[GENERAL] vacuum freeze in 96 - Mailing list pgsql-general

From Torsten Förtsch
Subject [GENERAL] vacuum freeze in 96
Date
Msg-id CAKkG4_nkYnKKSqwom=HM4k_81DmHqPALOuoz6JycrJxRfx-OFg@mail.gmail.com
Whole thread Raw
Responses Re: [GENERAL] vacuum freeze in 96
List pgsql-general
Tree view
Hi,

one of the major enhancements in 96 is skipping completely frozen pages in vacuum freeze. I assume that requires a special bit on the page.

If I upgrade from 93 using pg_upgrade, that is re-using the data files, can it still do that? Or do I have to recreate the table?

Thanks,
Torsten

pgsql-general by date:

Previous
From: Torsten Förtsch
Date:
Subject: Re: [GENERAL] is this a known bug in 9.6?
Next
From: John R Pierce
Date:
Subject: Re: [GENERAL] CRM where pg is a first class citizen?