Re: Odd behavior with indices

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Odd behavior with indices
Дата
Msg-id 3108.1457135621@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Odd behavior with indices  (Merlin Moncure <mmoncure@gmail.com>)
Список pgsql-performance
Дерево обсуждения 
Merlin Moncure <mmoncure@gmail.com> writes:
> On Mon, Feb 29, 2016 at 12:47 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> FWIW, PG >= 9.5 will ignore a LIMIT 1 inside an EXISTS, so that you get
>> the same plan with or without it.  But that does act as an optimization
>> fence in earlier releases.

> Does 'offset 0' still work as it did?

Yes.

            regards, tom lane

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

Предыдущее
От: Justin Pryzby
Дата:
Сообщение: Re: Clarification on using pg_upgrade
Следующее
От: Tory M Blue
Дата:
Сообщение: using stale statistics instead of current ones because stats collector is not responding