Re: which one is faster

From: Szymon Guz <mabewlun(at)gmail(dot)com>
To: AI Rumman <rummandba(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: which one is faster
Date: 2010-10-26 10:59:05
Message-ID: AANLkTikWbbFNykGXdobR06dsePn40JrBYvfFZLmu+H1j@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 26 October 2010 12:56, AI Rumman <rummandba(at)gmail(dot)com> wrote:

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

Check the query plan, both queries are the same.

regards
Szymon

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Divakar Singh 2010-10-26 11:44:28 Re: Postgres insert performance and storage requirement compared to Oracle
Previous Message AI Rumman 2010-10-26 10:56:48 which one is faster