Re: Vacuum errors and warnings
От | Rich Ryan |
---|---|
Тема | Re: Vacuum errors and warnings |
Дата | |
Msg-id | 045c01c181e6$1a9fdc70$1a02a8c0@gateway обсуждение исходный текст |
Ответ на | papers on datatype design (Brook Milligan <brook@biology.nmsu.edu>) |
Список | pgsql-general |
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)
В списке pgsql-general по дате отправления: