Re: [BUGS] vacuum analyze corrupts db with larger tuples (< 8k)
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Dirk Lutzebaeck <lutzeb@aeccom.com>
Cc: pgsql-bugs@postgreSQL.org
Date: 2000-01-05T14:38:50Z
Lists: pgsql-bugs
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