index scan over composite type

Поиск
Список
Период
Сортировка
От Teodor Sigaev
Тема index scan over composite type
Дата
Msg-id a6b22369-e3bf-4d49-f59d-0c41d3551e81@sigaev.ru
обсуждение исходный текст
Ответы Re: index scan over composite type  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Hi!

I'm not understand why postgres prefers to sort table instead of using 
index only scan when query is a simple inner join on composite type. 
Query with equality clause with constant works fine with index scan but 
join not. Could somebody point me why? Thank you.

And I'm not able to force merge_join with index scans with any 
combination of enable_* variables.

  Attached script is a self-contained test script. Pg config file is 
default.

explain
select
     a.idv, b.idv
from
     a, b
where
     a.idv = b.idv;


  Merge Join  (cost=25751.64..27751.64 rows=100000 width=74)
    Merge Cond: (a.idv = b.idv)
    ->  Sort  (cost=12875.82..13125.82 rows=100000 width=37)
          Sort Key: a.idv
          ->  Seq Scan on a  (cost=0.00..1834.00 rows=100000 width=37)
    ->  Sort  (cost=12875.82..13125.82 rows=100000 width=37)
          Sort Key: b.idv
          ->  Seq Scan on b  (cost=0.00..1834.00 rows=100000 width=37)

-- 
Teodor Sigaev                      E-mail: teodor@sigaev.ru
                                       WWW: http://www.sigaev.ru/

Вложения

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Postgres 11 release notes
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Postgres 11 release notes