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

Поиск
Список
Период
Сортировка
От Greg Sabino Mullane
Тема Re: Backends stalled in 'startup' state: index corruption
Дата
Msg-id 20120526172638.GE10277@tinybird.home
обсуждение исходный текст
Ответ на Re: Backends stalled in 'startup' state: index corruption  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Backends stalled in 'startup' state: index corruption  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Sat, May 26, 2012 at 01:25:29PM -0400, Tom Lane wrote:
> 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.

True. I'll try to get a high water mark when (er...if!) it happens again.

--
Greg Sabino Mullane greg@endpoint.com
End Point Corporation
PGP Key: 0x14964AC8

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Backends stalled in 'startup' state: index corruption
Следующее
От: Jan-Benedict Glaw
Дата:
Сообщение: Re: VIP: new format for psql - shell - simple using psql in shell