"Bruce Momjian" <pgman@candle.pha.pa.us> wrote:
> We don't have a checker because if it is corrupt, it will mention
> something in the server logs or correct it automatically. Corruption is
> very rare, usually hardware flakiness.
I agree about the fact that corruption is very rare but sometimes I got
a "duplicate primary key" and the only solution was dump the DB,
edit the dump and restore the DB.
If the dump is uge ( like 400 MB ) is a lot of down time :-(
The problem disappeared after removing the reindex on that table
scheduled each morning.
Regards
Gaetano Mendola.