This definitely looks like index corruption, but blaming it on the
filesystem might be premature. I'm wondering if this could be an
artifact of the WAL-replay bug fixed in 9.1.6. I'd suggest updating
and then reindexing the index ...
We are running 9.1.2 it seems:
select version();
version
----------------------------------------------------------------------------------------------------------------------------------------
PostgreSQL 9.1.2 on x86_64-apple-darwin, compiled by i686-apple-darwin10-gcc-4.2.1 (GCC) 4.2.1 (Apple Inc. build 5666) (dot 3), 64-bit
We'll look into upgrading to 9.1.6.
Cheers
Marco
-- So young, and already so unknown -- Pauli
blog: http://mcraveiro.blogspot.com
