Re: [9.2devel] why it doesn't do index scan only?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: depesz(at)depesz(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [9.2devel] why it doesn't do index scan only?
Date: 2011-10-08 16:47:46
Message-ID: 11589.1318092466@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hubert depesz lubaczewski <depesz(at)depesz(dot)com> 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2011-10-08 17:04:11 Re: [9.2devel] why it doesn't do index scan only?
Previous Message hubert depesz lubaczewski 2011-10-08 16:39:12 [9.2devel] why it doesn't do index scan only?