Re: [GENERAL] Very suspicious plan difference for select and corresponding delete queries PostgreSQL 9.6.2

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [GENERAL] Very suspicious plan difference for select and corresponding delete queries PostgreSQL 9.6.2
Дата
Msg-id 4119.1494250196@sss.pgh.pa.us
обсуждение исходный текст
Ответ на [GENERAL] Very suspicious plan difference for select and corresponding deletequeries PostgreSQL 9.6.2  (Maxim Boguk <maxim.boguk@gmail.com>)
Список pgsql-general
Maxim Boguk <maxim.boguk@gmail.com> writes:
> I can not see any possible/logical/realistic reason for the database to
> switch between INDEX ONLY SCAN and SEQ SCAN for EXIST part of query in this
> two cases.

If you'd done an EXPLAIN VERBOSE, you'd have noted that the scan was
returning ctid, which it could not get out of the index.  This is
necessary for possible EPQ rechecks.

            regards, tom lane


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

Предыдущее
От: Maxim Boguk
Дата:
Сообщение: [GENERAL] Very suspicious plan difference for select and corresponding deletequeries PostgreSQL 9.6.2
Следующее
От: PAWAN SHARMA
Дата:
Сообщение: [GENERAL] Migration Query