hubert depesz lubaczewski <depesz@xxxxxxxxxx> writes: > it is selecting 20 rows out of 30 million. why is it: > 1. not using index only scan > 2. not using even normal index scan? It thinks the bitmap scan is cheaper. Whether that's true or not is not very clear, but nobody is claiming that the costing of index-only scans is accurate yet. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
