Counting Distinct Records - Mailing list pgsql-sql

From Thomas F.O'Connell
Subject Counting Distinct Records
Date
Msg-id 1B2F7B00-3808-11D9-95C2-000D93AE0944@sitening.com
Whole thread Raw
Responses Re: Counting Distinct Records
List pgsql-sql
I am wondering whether the following two forms of SELECT statements are 
logically equivalent:

SELECT COUNT( DISTINCT table.column ) ...

and

SELECT DISTINCT COUNT( * ) ...

If they are the same, then why is the latter query much slower in 
postgres when applied to the same FROM and WHERE clauses?

Furthermore, is there a better way of performing this sort of operation 
in postgres (or just in SQL in general)?

Thanks!

-tfo

--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-0005



pgsql-sql by date:

Previous
From: carex@skynet.be (carex)
Date:
Subject: Re: select using regexp does not use indexscan
Next
From: Stephan Szabo
Date:
Subject: Re: Counting Distinct Records