Re: index-only scans vs. Hot Standby, round two

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: index-only scans vs. Hot Standby, round two
Дата
Msg-id 24054.1334585976@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: index-only scans vs. Hot Standby, round two  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Ответы Re: index-only scans vs. Hot Standby, round two  (Simon Riggs <simon@2ndQuadrant.com>)
Список pgsql-hackers
Heikki Linnakangas <heikki.linnakangas@enterprisedb.com> writes:
> Can we have a "soft" hot standby conflict that doesn't kill the query, 
> but disables index-only-scans?

Well, there wouldn't be any way for the planner to know whether an
index-only scan would be safe or not.  I think this would have to look
like a run-time fallback.  Could it be structured as "return that the
page's all-visible bit is not set, instead of failing?"  Or am I
confused about where the conflict is coming from?
        regards, tom lane


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

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: JSON for PG 9.2
Следующее
От: Merlin Moncure
Дата:
Сообщение: Re: JSON for PG 9.2