Re: pg_verify_checksums failure with hash indexes

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>
Cc: Michael Paquier <michael(at)paquier(dot)xyz>, Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, Robert Haas <robertmhaas(at)gmail(dot)com>
Subject: Re: pg_verify_checksums failure with hash indexes
Date: 2018-09-03 13:51:40
Message-ID: 15890.1535982700@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> writes:
> AFAICS, this problem exists in 9.6 and prior branches as well,
> although, I can't test it. I am not sure whether we need to backpatch
> this beyond 10 (where hash indexes are WAL logged) as prior to that
> hash-indexes are anyway not-reliable. What's your opinion?

Presumably, any patch for pre-10 would look completely different
as the hash index code was quite different. I can't see that it's
worth the development time to do something there, especially if
you lack an easy way to test.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2018-09-03 14:06:17 Re: TR: pgadmin not displaying data from postgresql_fdw
Previous Message Yugo Nagata 2018-09-03 13:06:18 Re: pg_verify_checksums -d option (was: Re: pg_verify_checksums -r option)