Re: Autovacuum fails to keep visibility map up-to-date in mostly-insert-only-tables

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: Autovacuum fails to keep visibility map up-to-date in mostly-insert-only-tables
Дата
Msg-id 5445AC2E.7030302@agliodbs.com
обсуждение исходный текст
Ответ на Autovacuum fails to keep visibility map up-to-date in mostly-insert-only-tables  (Alexey Bashtanov <bashtanov@imap.cc>)
Ответы Re: Autovacuum fails to keep visibility map up-to-date in mostly-insert-only-tables
Список pgsql-hackers
On 10/20/2014 05:39 PM, Jim Nasby wrote:
> Or maybe vacuum isn't the right way to handle some of these scenarios.
> It's become the catch-all for all of this stuff, but maybe that doesn't
> make sense anymore. Certainly when it comes to dealing with inserts
> there's no reason we *have* to do anything other than set hint bits and
> possibly freeze xmin.

+1

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com



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

Предыдущее
От: Jim Nasby
Дата:
Сообщение: Re: Autovacuum fails to keep visibility map up-to-date in mostly-insert-only-tables
Следующее
От: Jim Nasby
Дата:
Сообщение: Re: Proposal: Log inability to lock pages during vacuum