Akash Garg <akash.garg@gmail.com> 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