Akash Garg <akash.garg@xxxxxxxxx> writes: > I get this error when I run a VACUUM: > INFO: vacuuming "pg_toast.pg_toast_100194" > vacuumdb: vacuuming of database "friend" failed: ERROR: could not > open segment 1 of relation "pg_toast_100194_index" (target block > 1226167840): No such file or directory > I'm assuming I can just delete and recreate the index in question, > although I'm not sure which index or table it's talking about. Any > ideas? This probably means a corrupt next-page link in some page of the index. I'd suggest REINDEX TABLE pg_toast.pg_toast_100194; You might want to do the usual song and dance about memory and disk hardware checks, too. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
