]> granicus.if.org Git - postgresql/commit
Fix handling of all-zero pages in SP-GiST vacuum.
authorHeikki Linnakangas <heikki.linnakangas@iki.fi>
Mon, 27 Jul 2015 09:28:21 +0000 (12:28 +0300)
committerHeikki Linnakangas <heikki.linnakangas@iki.fi>
Mon, 27 Jul 2015 09:32:30 +0000 (12:32 +0300)
commit863af3a3797a3a8ca19c9bdd57c5f5b538e04e22
tree723b67d8e7db175f4c9db961f0513ce9842741ec
parent8352b141f7f5c0bcdfbc32555f65a5ba0fd390d1
Fix handling of all-zero pages in SP-GiST vacuum.

SP-GiST initialized an all-zeros page at vacuum, but that was not
WAL-logged, which is not safe. You might get a torn page write, when it gets
flushed to disk, and end-up with a half-initialized index page. To fix,
leave it in the all-zeros state, and add it to the FSM. It will be
initialized when reused. Also don't set the page-deleted flag when recycling
an empty page. That was also not WAL-logged, and a torn write of that would
cause the page to have an invalid checksum.

Backpatch to 9.2, where SP-GiST indexes were added.
src/backend/access/spgist/spgvacuum.c
src/include/access/spgist_private.h