performance difference in count(1) vs. count(*)?

From: Markus Bertheau <twanger(at)bluetwanger(dot)de>
To: pgsql-sql(at)postgresql(dot)org
Subject: performance difference in count(1) vs. count(*)?
Date: 2002-07-28 15:50:22
Message-ID: 1027871441.7362.0.camel@saphir
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello,

is there a difference performance-wise between select count(1) and
select count(*)?

--
Markus Bertheau.
Berlin, Berlin.
Germany.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2002-07-28 17:02:49 Re: performance difference in count(1) vs. count(*)?
Previous Message Dan Langille 2002-07-27 21:26:02 using LIMIT only on primary table