Re: Error while vacuuming

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