Re: index use again and again - Mailing list pgsql-general

Holger Marzen <holger@marzen.de> writes:
> Are 152428 rows not enough to use the index?

More like "there are too many rows to use the index".

You've got a query that is estimated to hit 22322/152428 = 15% of the
table.  If the rows in question are uniformly scattered through the
table then the system will certainly have to read every block of the
table to get them all.  It may as well read the table sequentially,
rather than do the extra I/O to read the index too.

            regards, tom lane