Postgres Pro
Downloads
Home   >   mailing lists

Re: which one is faster - Mailing list pgsql-performance

From Szymon Guz
Subject Re: which one is faster
Date
Msg-id AANLkTikWbbFNykGXdobR06dsePn40JrBYvfFZLmu+H1j@mail.gmail.com
Whole thread Raw
In response to which one is faster  (AI Rumman <rummandba@gmail.com>)
Responses Re: which one is faster
List pgsql-performance
Tree view


On 26 October 2010 12:56, AI Rumman <rummandba@gmail.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

pgsql-performance by date:

Previous
From: AI Rumman
Date:
Subject: which one is faster
Next
From: Divakar Singh
Date:
Subject: Re: Postgres insert performance and storage requirement compared to Oracle