Postgres Pro
Downloads
Home   >   mailing lists

Re: DISABLE_PAGE_SKIPPING option for vacuumdb - Mailing list pgsql-hackers

From Robert Haas
Subject Re: DISABLE_PAGE_SKIPPING option for vacuumdb
Date
Msg-id CA+TgmoZPSiDiWjNTqn33D7PeUooRAcpEXM=r6ccc3+wFODMjoA@mail.gmail.com
Whole thread Raw
In response to DISABLE_PAGE_SKIPPING option for vacuumdb  (Masahiko Sawada <sawada.mshk@gmail.com>)
Responses Re: DISABLE_PAGE_SKIPPING option for vacuumdb  (Masahiko Sawada <sawada.mshk@gmail.com>)
List pgsql-hackers
Tree view 
On Thu, Sep 8, 2016 at 1:32 PM, Masahiko Sawada <sawada.mshk@gmail.com> wrote:
> Attached patch add --disable-page-skipping option to vacuumed command for 9.6.
> If by any chance the freeze map causes the serious data corruption bug
> then the user will want to run pg_check_visible() and vacuum with
> DISABLE_PAGE_SKIPPING option to the multiple tables having problem.
> In this case, I think that this option for vacuumdb would be convenient.
>
> Please give me feedback.

I think this isn't really necessary.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Push down more full joins in postgres_fdw
Next
From: Tom Lane
Date:
Subject: Re: PassDownLimitBound for ForeignScan/CustomScan