Re: which one is faster

From: Szymon Guz <mabewlun(at)gmail(dot)com>
To: Marcin Mirosław <marcin(at)mejor(dot)pl>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: which one is faster
Date: 2010-10-26 12:05:36
Message-ID: AANLkTi=sOW-X+DcZPaBk1S_sHzJV97XrSOHmsSXsYpeo@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

2010/10/26 Marcin Mirosław <marcin(at)mejor(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Grzegorz Jaśkiewicz 2010-10-26 12:08:37 Re: which one is faster
Previous Message Marcin Mirosław 2010-10-26 11:59:03 Re: which one is faster