On 07/22/2012 02:00 PM, leo xu wrote:
> hello everyone:
> my pg version is 9.1.2 running on red hat 5.4 x64 servers.one
> day,i found all database indexes can't work,reindex database,it can work,but
> some table has primary key,found exists the same two records in table.
When did this start happening? At random? After a server crash or power
loss? After an administrative action?
Are you running with fsync=off or using storage that has write caching
enabled?
--
Craig Ringer