Missing segment 3 of index

From: "Jim Buttafuoco" <jim(at)contactbda(dot)com>
To: "pgsql-hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Missing segment 3 of index
Date: 2005-03-25 23:36:02
Message-ID: 20050325233236.M45156@contactbda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

All,

I had to abort a vacuum full after 36 hours on a large table (16 million rows). I started the vacuum again and after
10 minutes in got to the place I aborted it (control-c) yesterday. I recieved the following error

ERROR: could not open segment 3 of relation "emi_110101_idx1" (target block 2079965576): No such file or directory

Will a REINDEX fix this or do I need to drop the index instead?

Thanks
Jim

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message John Hansen 2005-03-25 23:42:19 Re: Patch for collation using ICU
Previous Message Otto Blomqvist 2005-03-25 23:34:00 Re: pg_autovacuum not having enough suction ?