Emanuel Calvo Franco escribió:
> 2009/3/10 Teodor Sigaev <teodor@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