Re: index corruption on composite primary key indexes

Excerpts from Ng, Stan's message of mié dic 15 21:07:57 -0300 2010:

> Now I just need to get my head wrapped around the corner cases of MVCC
> + indexes. From a layman's perspective, it seems the index should only
> operate on the latest version. Perhaps there's a pgsql configuration
> option or hint on the index that I'm missing... The hunt continues!

All tuples need to have index pointers, even the dead ones.  They (the
index pointers to dead tuples) are also cleaned up by vacuum.  There's
an optimization called HOT that allow them to be skipped in some cases;
you may want to read
http://git.postgresql.org/gitweb?p=postgresql.git;a=blob;f=src/backend/access/heap/README.HOT

--
Álvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support