On 11 November 2012 23:24, Tom Lane <t...@sss.pgh.pa.us> wrote: > Practically all WAL record types that touch multiple pages have some > bug of this type. In addition to btree_xlog_split, I found that > heap_xlog_update, ginRedoDeletePage, spgRedoAddLeaf, spgRedoMoveLeafs, > spgRedoAddNode, spgRedoSplitTuple, and spgRedoPickSplit fail to hold > locks as required to make their updates safe for concurrent queries. > (I'm not totally sure about ginRedoDeletePage, but the original action > definitely locks the pages simultaneously, and it's not clear that it's > safe not to.) Most of these are okay in cases without any full-page > images, but could fail if the wrong subset of the pages-to-be-touched > were processed by RestoreBkpBlocks. Some had bugs even without that :-(
Hmm, not good. Thanks for spotting. Do these changes do anything to actions that occur across multiple records? I assume not and think those are OK, agreed? -- Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers