Dmitry Tkach <[EMAIL PROTECTED]> writes:
> I am getting a weird failure, trying to vacuum a table in 7.3 - it says
> "ERROR: Index pg_toast_89407_index is not a btree".
That says the first page of the index was corrupted (version number
field didn't contain the right thing).
> Does it ring a bell to anyone? Any ideas what's wrong? Is it my database
> screwed up? I just created it today...
> I tried dropping and recreating it... and it seems to be working now.
Sounds like you just destroyed all the evidence :-(. I'd wonder about
hardware flakiness for one thing ...
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
