Re: [HACKERS] Skip all-visible pages during second HeapScan of CIC

Поиск
Список
Период
Сортировка
От Pavan Deolasee
Тема Re: [HACKERS] Skip all-visible pages during second HeapScan of CIC
Дата
Msg-id CABOikdPookxmtS9rJkZu7UQ7vfghtoYPQwisVL2C19KATknywQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [HACKERS] Skip all-visible pages during second HeapScan of CIC  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers


On Wed, Mar 8, 2017 at 8:08 AM, Robert Haas <robertmhaas@gmail.com> wrote:
On Tue, Mar 7, 2017 at 9:12 PM, Andres Freund <andres@anarazel.de> wrote:

>
> I wonder however, if careful snapshot managment couldn't solve this as
> well.  I have *not* thought a lot about this, but afaics we can easily
> prevent all-visible from being set in cases it'd bother us by having an
> "appropriate" xmin / registered snapshot.

Yeah, but that's a tax on the whole system.


May be we can do that only when patched CIC (or any other operation which may not like concurrent VM set) is in progress. We could use what Stephen suggested upthread to find that state. But right now it's hard to think because there is nothing on either side so we don't know what gets impacted by aggressive VM set and how.

Thanks,
Pavan

--
 Pavan Deolasee                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: [HACKERS] REINDEX CONCURRENTLY 2.0
Следующее
От: Robert Haas
Дата:
Сообщение: Re: [HACKERS] wait events for disk I/O