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

From Szymon Guz
Subject Re: which one is faster
Date
Msg-id AANLkTi=sOW-X+DcZPaBk1S_sHzJV97XrSOHmsSXsYpeo@mail.gmail.com
Whole thread Raw
In response to Re: which one is faster  (Marcin Mirosław <marcin@mejor.pl>)
Responses Re: which one is faster  (Grzegorz Jaśkiewicz <gryzman@gmail.com>)
List pgsql-performance


2010/10/26 Marcin Mirosław <marcin@mejor.pl>
W dniu 26.10.2010 12:59, Szymon Guz pisze:
> both queries are the same.

IMHO they aren't the same, but they returns the same value in this case.
I mean count(field) doesn't count NULL values, count(*) does it.
I'm writing this only for note:)
Regards


Yup, indeed. I omitted that note, as it was written that the field is primary key :).

regards
Szymon 

pgsql-performance by date:

Previous
From: Marcin Mirosław
Date:
Subject: Re: which one is faster
Next
From: Grzegorz Jaśkiewicz
Date:
Subject: Re: which one is faster