Re: Error while vacuuming

Sounds good -- I will try that. Will this REINDEX lock any queries
that are currently running on the database? And is there anway to
find out what table this toast table is related to?

Thanks,
Akash

On 7/18/05, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> 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
>