Re: Error while vacuuming

Akash Garg <akash(dot)garg(at)gmail(dot)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