which one is faster

From: AI Rumman <rummandba(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: which one is faster
Date: 2010-10-26 10:56:48
Message-ID: AANLkTimgjmGCcxjSmf6BvQ=BBGLBrMspfcFgWhrpsVVr@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Which one is faster?
select count(*) from talble
or
select count(id) from table
where id is the primary key.

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Szymon Guz 2010-10-26 10:59:05 Re: which one is faster
Previous Message Scott Carey 2010-10-26 07:22:44 Re: BBU Cache vs. spindles