How Postgresql Compares... Count(*) and others

From: Mark kirkwood <markir(at)slingshot(dot)co(dot)nz>
To: Sean Chittenden <sean-pgsql-general(at)chittenden(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: How Postgresql Compares... Count(*) and others
Date: 2001-07-22 03:06:52
Message-ID: 01072215065200.01868@spikey.slithery.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Last time I tested this on the big O ( early 8.0.x ) count(*) was always
fractionally quicker.... there was a body of thought at the time that said
count(1) or count(<field>) was quicker.... no idea where it came from.

I have not tried to see if it makes any difference in Postgresql...

regards

Mark

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dalibor Andzakovic 2001-07-22 03:21:09 databse design tools
Previous Message Martijn van Oosterhout 2001-07-22 02:37:50 Re: Performance impact of NULLs and variable length fields