Re: [PERFORM] Cheaper subquery scan not considered unless offset 0

Поиск
Список
Период
Сортировка
От David Rowley
Тема Re: [PERFORM] Cheaper subquery scan not considered unless offset 0
Дата
Msg-id CAKJS1f-0aAOKV=0L_fqzRUuVfrVi2v5izJGGNrJ-9x_PgfuhDQ@mail.gmail.com
обсуждение исходный текст
Ответ на [PERFORM] Cheaper subquery scan not considered unless offset 0  (Benjamin Coutu <ben.coutu@zeyos.com>)
Список pgsql-performance
Дерево обсуждения 
On 30 October 2017 at 00:24, Benjamin Coutu <ben.coutu@zeyos.com> wrote:
>   ->  Index Scan using "PK_items_ID" on items a  (cost=0.42..1.05 rows=1 width=332) (actual time=0.003..0.003 rows=1
loops=15521total=46.563)
 

I've never seen EXPLAIN output like that before.

Is this some modified version of PostgreSQL?

-- David Rowley                   http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training & Services


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

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

Предыдущее
От: Benjamin Coutu
Дата:
Сообщение: [PERFORM] Cheaper subquery scan not considered unless offset 0
Следующее
От: Benjamin Coutu
Дата:
Сообщение: Re: [PERFORM] Cheaper subquery scan not considered unless offset 0