Re: lazy_truncate_heap()

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: lazy_truncate_heap()
Дата
Msg-id 3DF8A552-B9BD-4496-88FE-55D1309BB25A@enterprisedb.com
обсуждение исходный текст
Ответ на lazy_truncate_heap()  (Simon Riggs <simon@2ndQuadrant.com>)
Ответы Re: lazy_truncate_heap()  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Re: lazy_truncate_heap()  (Simon Riggs <simon@2ndQuadrant.com>)
Список pgsql-hackers
On 31 Dec 2008, at 13:21, Simon Riggs <simon@2ndQuadrant.com> wrote:
>
> Both of these bugs are minor, but the effect of either/both of them is
> to cause more AccessExclusiveLocks than we might expect.
>
> For Hot Standby this means that many VACUUMs take AccessExclusiveLocks
> on relations, which would potentially lead to having queries cancelled
> for no reason at all.

Well by default it would just cause wal to pause briefly until the  
queries with those locks finish, no?


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

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Re: lazy_truncate_heap()
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: pg_dump roles support [Review]