Re: DISABLE_PAGE_SKIPPING option for vacuumdb

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: DISABLE_PAGE_SKIPPING option for vacuumdb
Date: 2016-09-13 17:17:20
Message-ID: CA+TgmoZPSiDiWjNTqn33D7PeUooRAcpEXM=r6ccc3+wFODMjoA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Sep 8, 2016 at 1:32 PM, Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2016-09-13 17:20:31 Re: PassDownLimitBound for ForeignScan/CustomScan
Previous Message Robert Haas 2016-09-13 16:58:14 Re: Push down more full joins in postgres_fdw