Re: vacuum hint on elog

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: vacuum hint on elog
Дата
Msg-id 20050122125633.GA31867@dcc.uchile.cl
обсуждение исходный текст
Ответ на vacuum hint on elog  (Neil Conway <neilc@samurai.com>)
Ответы Re: vacuum hint on elog  (Neil Conway <neilc@samurai.com>)
Список pgsql-patches
On Sat, Jan 22, 2005 at 11:28:52PM +1100, Neil Conway wrote:
> It occurred to me that if we elog(ERROR) during VACUUM, the vacuum
> activity hint will not be reset. This will result in all subsequent I/O
> by the current backend being treated by the bufmgr as though it resulted
> from VACUUM. While elog(ERROR) during VACUUM is not a common occurrence,
> I don't think it's wise to assume it is impossible.

Hmm ... I think you should rather use a PG_TRY/PG_CATCH block.  (Or
discover whether this is already done somewhere else ...)

--
Alvaro Herrera (<alvherre[@]dcc.uchile.cl>)
"El día que dejes de cambiar dejarás de vivir"

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

Предыдущее
От: Neil Conway
Дата:
Сообщение: vacuum hint on elog
Следующее
От: Neil Conway
Дата:
Сообщение: Re: vacuum hint on elog