Postgres Pro
Downloads
Home   >   mailing lists

Re: performance difference in count(1) vs. count(*)? - Mailing list pgsql-sql

From Tom Lane
Subject Re: performance difference in count(1) vs. count(*)?
Date
Msg-id 11471.1027875769@sss.pgh.pa.us
Whole thread Raw
In response to performance difference in count(1) vs. count(*)?  (Markus Bertheau <twanger@bluetwanger.de>)
List pgsql-sql
Tree view 
Markus Bertheau <twanger@bluetwanger.de> writes:
> is there a difference performance-wise between select count(1) and
> select count(*)?

Nope.  In fact, the latter is converted to the former during parsing.
        regards, tom lane

pgsql-sql by date:

Previous
From: Markus Bertheau
Date:
Subject: performance difference in count(1) vs. count(*)?
Next
From: Josh Berkus
Date:
Subject: Abbr. for TIMESTAMP WITHOUT TIME ZONE?