Re: [BUGS] vacuum analyze corrupts db with larger tuples (< 8k)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Dirk Lutzebaeck <lutzeb(at)aeccom(dot)com>
Cc: pgsql-bugs(at)postgreSQL(dot)org
Subject: Re: [BUGS] vacuum analyze corrupts db with larger tuples (< 8k)
Date: 2000-01-05 14:38:50
Message-ID: 16933.947083130@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Dirk Lutzebaeck <lutzeb(at)aeccom(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruce Momjian 2000-01-05 17:46:17 Re: [BUGS] vacuum analyze corrupts db with larger tuples (< 8k)
Previous Message Dirk Lutzebaeck 2000-01-05 07:47:28 Re: [BUGS] vacuum analyze corrupts db with larger tuples (< 8k)