I delete rows and indexes, then copy in new rows, then create the indexes
over again every night, so that should be equivalent to rebuild. It's
possible my disk has some bad blocks on it. These errors only happen every
once in awhile, so I"ll change the DB to a different disk and see what
happens.
Thanks,
Rich
> NOTICE: Rel r_maryland: Uninitialized page 730 - fixing
> NOTICE: Index cfsoidmaryland: pointer to EmptyPage (blk 730 off 4) -
fixing
> NOTICE: Index cfsoidmaryland: pointer to EmptyPage (blk 730 off 8) -
fixing
>These are not good. Is it possible you've got disk hardware problems?
>A possible answer is to rebuild that damaged index with REINDEX, but if
>the problems keep coming back then you've got something very wrong.
>regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)