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

Поиск
Список
Период
Сортировка
От Greg Sabino Mullane
Тема Re: Backends stalled in 'startup' state: index corruption
Дата
Msg-id 20120528110951.GF10277@tinybird.home
обсуждение исходный текст
Ответ на Re: Backends stalled in 'startup' state: index corruption  (Jeff Frost <jeff@pgexperts.com>)
Ответы Re: Backends stalled in 'startup' state: index corruption  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Sun, May 27, 2012 at 05:44:15PM -0700, Jeff Frost wrote:
> On May 27, 2012, at 12:53 PM, Tom Lane wrote:
> > occurring, they'd take long enough to expose the process to sinval
> > overrun even with not-very-high DDL rates.
> As it turns out, there are quite a few temporary tables created.

For the record, same here. We do *lots* of DDL (hence the cronjobs
to vac/reindex system catalogs).

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

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

Предыдущее
От: Marti Raudsepp
Дата:
Сообщение: Re: Bogus nestloop rows estimate in 8.4.7
Следующее
От: Andres Freund
Дата:
Сообщение: Re: pg_stat_statements temporary file