Postgres Pro
Downloads
Home   >   mailing lists

DISABLE_PAGE_SKIPPING option for vacuumdb - Mailing list pgsql-hackers

From Masahiko Sawada
Subject DISABLE_PAGE_SKIPPING option for vacuumdb
Date
Msg-id CAD21AoDRzzQfD7qYznVnV4ipchO=R9PKaOtCx3TgNMS3Ymwf2w@mail.gmail.com
Whole thread Raw
Responses Re: DISABLE_PAGE_SKIPPING option for vacuumdb  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Tree view 
Hi,

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.

Regards,

--
Masahiko Sawada
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center
Attachment

pgsql-hackers by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: Parallel tuplesort (for parallel B-Tree index creation)
Next
From: Erik Rijkers
Date:
Subject: logical replication WIP: FailedAssertion("!(list_length(stmt->tables) > 0)", File: "publicationcmds.c", Line: 350)