Postgres Pro
Downloads
Home   >   mailing lists

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

From Marcin Mirosław
Subject Re: which one is faster
Date
Msg-id 4CC6C287.8070803@mejor.pl
Whole thread Raw
In response to Re: which one is faster  (Szymon Guz <mabewlun@gmail.com>)
Responses Re: which one is faster  (Szymon Guz <mabewlun@gmail.com>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

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