pgsql: During the split, set checksum on an empty hash index page.

From: Amit Kapila <akapila(at)postgresql(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: During the split, set checksum on an empty hash index page.
Date: 2018-09-04 03:25:11
Message-ID: E1fx1xn-0005iy-Fr@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

During the split, set checksum on an empty hash index page.

On a split, we allocate a new splitpoint's worth of bucket pages wherein
we initialize the last page with zeros which is fine, but we forgot to set
the checksum for that last page.

We decided to back-patch this fix till 10 because we don't have an easy
way to test it in prior versions. Another reason is that the hash-index
code is changed heavily in 10, so it is not advisable to push the fix
without testing it in prior versions.

Author: Amit Kapila
Reviewed-by: Yugo Nagata
Backpatch-through: 10
Discussion: https://postgr.es/m/5d03686d-727c-dbf8-0064-bf8b97ffe850@2ndquadrant.com

Branch
------
REL_10_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/3b7a96a619f78f80b4a470a0dcde4c92b5b7141f

Modified Files
--------------
src/backend/access/hash/hashpage.c | 1 +
1 file changed, 1 insertion(+)

Browse pgsql-committers by date

  From Date Subject
Next Message Amit Kapila 2018-09-04 05:51:32 pgsql: Prohibit pushing subqueries containing window function calculati
Previous Message Alvaro Herrera 2018-09-03 16:06:34 pgsql: Remove pg_constraint.conincluding