Missing segment 3 of index - Mailing list pgsql-hackers

From Jim Buttafuoco
Subject Missing segment 3 of index
Date
Msg-id 20050325233236.M45156@contactbda.com
Whole thread Raw
Responses Re: Missing segment 3 of index
List 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



pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: minor windows & cygwin regression failures on stable branch
Next
From: "John Hansen"
Date:
Subject: Re: Patch for collation using ICU