Re: pg_verify_checksums failure with hash indexes

Поиск
Список
Период
Сортировка
Искать
От
Yugo Nagata
Тема
Re: pg_verify_checksums failure with hash indexes
Дата
Msg-id
20180829201015.d9d4fde2748910e86a13c0da@sraoss.co.jp
Ответ на
Список
Дерево обсуждения
pg_verify_checksums failure with hash indexes Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: pg_verify_checksums failure with hash indexes Bernd Helmle <mailings@oopsware.de>
Re: pg_verify_checksums failure with hash indexes Dilip Kumar <dilipbalaut@gmail.com>
Re: pg_verify_checksums failure with hash indexes Dilip Kumar <dilipbalaut@gmail.com>
Re: pg_verify_checksums failure with hash indexes Amit Kapila <amit.kapila16@gmail.com>
Re: pg_verify_checksums failure with hash indexes Robert Haas <robertmhaas@gmail.com>
Re: pg_verify_checksums failure with hash indexes Dilip Kumar <dilipbalaut@gmail.com>
Re: pg_verify_checksums failure with hash indexes Amit Kapila <amit.kapila16@gmail.com>
Re: pg_verify_checksums failure with hash indexes Dilip Kumar <dilipbalaut@gmail.com>
Re: pg_verify_checksums failure with hash indexes Amit Kapila <amit.kapila16@gmail.com>
Re: pg_verify_checksums failure with hash indexes Dilip Kumar <dilipbalaut@gmail.com>
Re: pg_verify_checksums failure with hash indexes Dilip Kumar <dilipbalaut@gmail.com>
Re: pg_verify_checksums failure with hash indexes Amit Kapila <amit.kapila16@gmail.com>
Re: pg_verify_checksums failure with hash indexes Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_verify_checksums failure with hash indexes Michael Paquier <michael@paquier.xyz>
Re: pg_verify_checksums failure with hash indexes Amit Kapila <amit.kapila16@gmail.com>
Re: pg_verify_checksums failure with hash indexes Michael Banck <michael.banck@credativ.de>
Re: pg_verify_checksums failure with hash indexes Yugo Nagata <nagata@sraoss.co.jp>
Re: pg_verify_checksums failure with hash indexes Michael Paquier <michael@paquier.xyz>
Re: pg_verify_checksums failure with hash indexes Amit Kapila <amit.kapila16@gmail.com>
Re: pg_verify_checksums failure with hash indexes Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_verify_checksums failure with hash indexes Amit Kapila <amit.kapila16@gmail.com>
Re: pg_verify_checksums failure with hash indexes Amit Kapila <amit.kapila16@gmail.com>
Re: pg_verify_checksums failure with hash indexes Amit Kapila <amit.kapila16@gmail.com>
Re: pg_verify_checksums failure with hash indexes Yugo Nagata <nagata@sraoss.co.jp>
Re: pg_verify_checksums failure with hash indexes Amit Kapila <amit.kapila16@gmail.com>
Re: pg_verify_checksums failure with hash indexes Yugo Nagata <nagata@sraoss.co.jp>
Re: pg_verify_checksums failure with hash indexes Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: pg_verify_checksums failure with hash indexes Yugo Nagata <nagata@sraoss.co.jp>
On Wed, 29 Aug 2018 16:01:53 +0530
Amit Kapila  wrote:

> > By the way, I think we can fix this also by clearing the header information of the last
> > page instead of setting a checksum to the unused page although I am not sure which way
> > is better.
> >
> 
> I think that can complicate the WAL logging of this operation which we
> are able to deal easily with log_newpage and it sounds quite hacky.
> The fix I have posted seems better, but I am open to suggestions.

Thank you for your explanation.  I understood  this way could make the
codes complicated, so I think the way you posted is better.


Regards,
-- 
Yugo Nagata 

В списке pgsql-hackers по дате отправления
От: Dilip Kumar
Дата:
От: Andrew Gierth
Дата:
Сообщение: Re: Catalog corruption
FAQ