Re: [HACKERS] DISABLE_PAGE_SKIPPING option for vacuumdb
On Wed, Sep 14, 2016 at 2:17 AM, Robert Haaswrote: > On Thu, Sep 8, 2016 at 1:32 PM, Masahiko Sawada 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. > Thank you for comment. Okay, I thought it would be useful for user who want to vacuum with disable_page_skipping specified table but it's non-essential. I pull it back. Thanks. Regards, -- Masahiko Sawada NIPPON TELEGRAPH AND TELEPHONE CORPORATION NTT Open Source Software Center -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Re: [HACKERS] DISABLE_PAGE_SKIPPING option for vacuumdb
On Thu, Sep 8, 2016 at 1:32 PM, Masahiko Sawadawrote: > 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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
[HACKERS] DISABLE_PAGE_SKIPPING option for vacuumdb
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 disable_page_skipping_option_for_vacuumdb_v1.patch Description: Binary data -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers