Postgres Pro
Downloads
Home   >   mailing lists

Re: [BUGS] vacuum analyze corrupts db with larger tuples (< 8k) - Mailing list pgsql-bugs

From Tom Lane
Subject Re: [BUGS] vacuum analyze corrupts db with larger tuples (< 8k)
Date
Msg-id 16933.947083130@sss.pgh.pa.us
Whole thread Raw
In response to Re: [BUGS] vacuum analyze corrupts db with larger tuples (< 8k)  (Dirk Lutzebaeck <lutzeb@aeccom.com>)
List pgsql-bugs
Tree view 
Dirk Lutzebaeck <lutzeb@aeccom.com> writes:
> Tom Lane writes:
>> I have applied the attached patch to the REL6_5 branch.  (There is
>> already similar code in the current branch.)  I'm afraid it won't
>> help you recover from an already-corrupted pg_statistic table, though.

> How can I recover from this? Simply delete the entries in pg_statistic?
> Is this possible?

It's worth a try, anyway: just DELETE FROM pg_statistic
and see what happens... but, depending on how badly pg_statistic is
messed up, that might itself crash...

            regards, tom lane

pgsql-bugs by date:

Previous
From: Dirk Lutzebaeck
Date:
Subject: Re: [BUGS] vacuum analyze corrupts db with larger tuples (< 8k)
Next
From: Bruce Momjian
Date:
Subject: Re: [BUGS] vacuum analyze corrupts db with larger tuples (< 8k)