Re: Backends stalled in 'startup' state: index corruption

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Backends stalled in 'startup' state: index corruption
Дата
Msg-id 25413.1338053129@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Backends stalled in 'startup' state: index corruption  (Greg Sabino Mullane <greg@endpoint.com>)
Ответы Re: Backends stalled in 'startup' state: index corruption  (Greg Sabino Mullane <greg@endpoint.com>)
Список pgsql-hackers
Greg Sabino Mullane <greg@endpoint.com> writes:
> On Sat, May 26, 2012 at 12:17:04PM -0400, Tom Lane wrote:
>> If you see any block numbers above about 20 then maybe the triggering
>> condition is a row relocation after all.

> Highest was 13.

Hm ... but wait, you said you'd done a VACUUM FULL on the catalogs.
So it's not clear whether this is reflective of the state at the time
the problem was happening.
        regards, tom lane


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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: VIP: new format for psql - shell - simple using psql in shell
Следующее
От: Greg Sabino Mullane
Дата:
Сообщение: Re: Backends stalled in 'startup' state: index corruption