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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [BUGS] vacuum analyze corrupts db with larger tuples (< 8k)
Дата
Msg-id 16933.947083130@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [BUGS] vacuum analyze corrupts db with larger tuples (< 8k)  (Dirk Lutzebaeck <lutzeb@aeccom.com>)
Список 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

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Dirk Lutzebaeck
Дата:
Сообщение: Re: [BUGS] vacuum analyze corrupts db with larger tuples (< 8k)
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: [BUGS] vacuum analyze corrupts db with larger tuples (< 8k)