Home > mailing lists

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

From	Markus Bertheau
Subject	performance difference in count(1) vs. count(*)?
Date	July 28, 2002 14:50:48
Msg-id	1027871441.7362.0.camel@saphir Whole thread Raw
Responses	Re: performance difference in count(1) vs. count(*)? (Tom Lane <tgl@sss.pgh.pa.us>)
List	pgsql-sql

Hello,

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

-- 
Markus Bertheau.
Berlin, Berlin.
Germany.

From: "Dan Langille"
Date: 27 July 2002, 20:27:42
Subject: using LIMIT only on primary table

From: Tom Lane
Date: 28 July 2002, 16:02:56
Subject: Re: performance difference in count(1) vs. count(*)?