Emanuel Calvo Franco escribió: > 2009/3/10 Teodor Sigaev <teo...@sigaev.ru>: > >> Apparently there's a crash involved ... > > > > Are other indexes on that table broken? ( Just count(*) with only index scan > > enabled )
> Yes, there are some btree indexes broken. > Alvaro asked him if the option fsync is off. We don't know whether the btree indexes are on the same table, though :-) Since he already erased all the evidence, I don't think there's anything to do about this for now. -- Alvaro Herrera http://www.CommandPrompt.com/ 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