Postgres Pro
Downloads
Home   >   mailing lists

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

From Torsten Förtsch
Subject Re: [GENERAL] vacuum freeze in 96
Date
Msg-id CAKkG4_=eekiyZ6d5+n7uyjAL-t4UZc28obVqwgr_o6x8ZV+p7A@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] vacuum freeze in 96  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-general
Tree view
On Wed, Dec 14, 2016 at 5:59 AM, Michael Paquier <michael.paquier@gmail.com> wrote:
On Wed, Dec 14, 2016 at 5:00 AM, Torsten Förtsch <tfoertsch123@gmail.com> wrote:
> 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.

The freeze map uses an additional bit in the vm, and pg_upgrade would
take care of the conversion. 

Thanks. That makes sense.

pgsql-general by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: [GENERAL] pg_dump and quoted identifiers
Next
From: Mikhail
Date:
Subject: [GENERAL] Re[2]: [GENERAL] pg_upgrade 9.0 to 9.6