Excerpts from Kevin Grittner's message of mar jun 07 20:45:43 -0400 2011: > During testing of the SSI DDL changes I noticed that a REINDEX INDEX > created a predicate lock on page 0 of the index.
Err, in a btree, page 0 is the metapage, not the root. The root page moves around, but it's never page 0 (it starts at page 1). I think GIN indexes also have metapages, not sure about the others. Not sure if this changes your reasoning at all, just thought it was worth mentioning. > This is pretty > harmless, but mildly annoying. There are a few other places where > it would be good to suppress predicate locks; these are listed on > the R&D section of the Wiki. I hope to clean some of these up in > 9.2. Unless a very clean and safe fix for the subject issue pops out > on further review, I'll add this to that list. -- Álvaro Herrera <alvhe...@commandprompt.com> The PostgreSQL Company - Command Prompt, Inc. PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers