Re: [BUGS] feature request: Loose index scans

2010-03-16 Thread Tom Lane
Robert Haas writes: > On Mon, Mar 15, 2010 at 3:04 PM, Gregg Lind wrote: >> As per http://osdir.com/ml/pgsql-hackers/2010-03/msg00331.html, I would >> certainly find it helpful is count(distinct(myfield)) wasn't a full index >> scan. > We should maybe add this to our Todo file, if it's not there

Re: [BUGS] feature request: Loose index scans

2010-03-16 Thread Robert Haas
On Mon, Mar 15, 2010 at 3:04 PM, Gregg Lind wrote: > As per http://osdir.com/ml/pgsql-hackers/2010-03/msg00331.html, I would > certainly find it helpful is count(distinct(myfield)) wasn't a full index > scan. We should maybe add this to our Todo file, if it's not there already (I don't see it on

[BUGS] feature request: Loose index scans

2010-03-15 Thread Gregg Lind
As per http://osdir.com/ml/pgsql-hackers/2010-03/msg00331.html, I would certainly find it helpful is count(distinct(myfield)) wasn't a full index scan. Gregg Lind