Re: getting rid of SnapshotNow

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: getting rid of SnapshotNow
Дата
Msg-id 4668.1374603872@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: getting rid of SnapshotNow  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: getting rid of SnapshotNow  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> On Tue, Jul 23, 2013 at 12:28 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> As far as get_actual_variable_range() is concerned, an MVCC snapshot
>> would probably be the thing to use anyway;

> That surprises me, though.  I really thought the point was to cost the
> index scan, and surely that will be slowed down even by entries we
> can't see.

No, the usage (or the main usage anyway) is for selectivity estimation,
ie how many rows will the query fetch.
        regards, tom lane



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

Предыдущее
От: Jeff Janes
Дата:
Сообщение: Re: maintenance_work_mem and CREATE INDEX time
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: [v9.4] row level security