count(distinct) - Mailing list pgsql-sql

From Zdravko Balorda
Subject count(distinct)
Date
Msg-id 498C4326.8080500@siix.com
Whole thread Raw
Responses Re: count(distinct)
List pgsql-sql
Hi,

this is probably an old issue but I'm not all that experienced.

I wonder if an index can be accessed rather directly, as to speed up
a query like "select count(distinct())", by simply calculating the 
number of branches (leaves) an index has. Or at least to skip sorting.

Best regards, Zdravko



pgsql-sql by date:

Previous
From: Boycott TechForums
Date:
Subject: test
Next
From: Richard Huxton
Date:
Subject: Re: count(distinct)