Re: Merge Join chooses very slow index scan

random_page_cost = 4
seq_page_cost = 1

Regardless of the the choice to use the index scan and random access to the
rows, how come in the second query with the freq > -1 condition, it accesses
far fewer pages with the same index scan even though no rows are filtered
out?

Thanks



--
View this message in context:
http://postgresql.nabble.com/Merge-Join-chooses-very-slow-index-scan-tp5842523p5842527.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.