Received: from leela.webpack.hosteurope.de (leela.one-2-one.net
	[217.115.142.65])
	by postgresql.org (Postfix) with ESMTP id 02F6E4750F5
	for <pgsql-sql@postgresql.org>; Sun, 28 Jul 2002 11:50:46 -0400 (EDT)
Received: from dsl-213-023-038-181.arcor-ip.net
	(bert@dsl-213-023-038-181.arcor-ip.net [213.23.38.181])
	by leela.webpack.hosteurope.de (8.11.0/8.11.0) with ESMTP id
	g6SFqcc02056
	for <pgsql-sql@postgresql.org>; Sun, 28 Jul 2002 17:52:39 +0200
X-Envelope-To: <pgsql-sql@postgresql.org>
Subject: performance difference in count(1) vs. count(*)?
From: Markus Bertheau <twanger@bluetwanger.de>
To: pgsql-sql@postgresql.org
Content-Type: text/plain
Content-Transfer-Encoding: 7bit
X-Mailer: Ximian Evolution 1.0.8 
Date: 28 Jul 2002 17:50:22 +0200
Message-Id: <1027871441.7362.0.camel@saphir>
Mime-Version: 1.0
X-Archive-Number: 200207/425
X-Sequence-Number: 8803

Hello,

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

-- 
Markus Bertheau.
Berlin, Berlin.
Germany.