Re: Why does VACUUM FULL bother locking pages?

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: Why does VACUUM FULL bother locking pages?
Дата
Msg-id KGEFLMPJFBNNLNOOOPLGCEFHCJAA.simon@2ndquadrant.com
обсуждение исходный текст
Ответ на Why does VACUUM FULL bother locking pages?  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Ответы Re: Why does VACUUM FULL bother locking pages?  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Список pgsql-hackers
> Alvaro Herrera wrote
> The only caller of both is
> repair_frag, whose only caller in turn is full_vacuum_rel.

...bgwriter still needs to access blocks. The WAL system relies on the
locking behaviour for recoverability, see comments in LockBuffer() and
SyncOneBuffer().

...I do think there's lots still to optimise in VACUUM FULL though...

Best Regards, Simon Riggs



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

Предыдущее
От: "Jonah H. Harris"
Дата:
Сообщение: Re: Why does VACUUM FULL bother locking pages?
Следующее
От: "Simon Riggs"
Дата:
Сообщение: Re: statement_timeout logging