Postgres Pro
Downloads
Home   >   mailing lists

How Postgresql Compares... Count(*) and others - Mailing list pgsql-general

From Mark kirkwood
Subject How Postgresql Compares... Count(*) and others
Date
Msg-id 01072215065200.01868@spikey.slithery.org
Whole thread Raw
Responses Re: How Postgresql Compares... Count(*) and others  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: How Postgresql Compares... Count(*) and others  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Joshua Jore
Date:
Subject: Re: Microsoft SQL Server Replication
Next
From: Bruce Momjian
Date:
Subject: Re: Re: Examples of using bytea type