Re: [NOVICE] WHERE clause not used when index is used

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: [NOVICE] WHERE clause not used when index is used
Дата
Msg-id CANP8+jKaTCYBgvFVtOVEOXHD0nHmaqGaDreK7oNcfiQL1nardw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [NOVICE] WHERE clause not used when index is used  (Simon Riggs <simon@2ndQuadrant.com>)
Ответы Re: [NOVICE] WHERE clause not used when index is used  (Tobias Florek <postgres@ibotty.net>)
Re: [NOVICE] WHERE clause not used when index is used  (Peter Geoghegan <pg@heroku.com>)
Список pgsql-hackers
Дерево обсуждения
On 2 March 2016 at 10:57, Simon Riggs <simon@2ndquadrant.com> wrote:
On 1 March 2016 at 20:03, Tom Lane <tgl@sss.pgh.pa.us> wrote:
 
In any event, I am now of the opinion that this patch needs to be reverted
outright and returned to the authors for redesign.  There are too many
things wrong with it and too little reason to think that we have to have
it in 9.5.

Agreed; I'd already got to this thought while reading the thread.

I'll get on with that.

The patch is not of great importance to us? Since we are past 9.6 deadline it seems just worth reverting and leaving for next release to come back with a more isolated optimization. I don't want to add the last CF workload with this. 

Reverted patch in HEAD and 9.5

Later, I will add the tests we discovered here to index scans, so that further optimization work is more easily possible.

Thanks Tom, Petr for analysis; thanks Jeff for bisecting.

--
Simon Riggs                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

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

Предыдущее
От: lannis
Дата:
Сообщение: Re: redo failed in physical streaming replication while stopping the master server
Следующее
От: Tobias Florek
Дата:
Сообщение: Re: [NOVICE] WHERE clause not used when index is used