Re: [BUGS] feature request: Loose index scans

2010-03-16 Thread Robert Haas
On Mon, Mar 15, 2010 at 3:04 PM, Gregg Lind gregg.l...@gmail.com 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

Re: [BUGS] feature request: Loose index scans

2010-03-16 Thread Tom Lane
Robert Haas robertmh...@gmail.com writes: On Mon, Mar 15, 2010 at 3:04 PM, Gregg Lind gregg.l...@gmail.com 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

[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