Re: which one is faster

From: Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>
To: Szymon Guz <mabewlun(at)gmail(dot)com>
Cc: Marcin Mirosław <marcin(at)mejor(dot)pl>, pgsql-performance(at)postgresql(dot)org
Subject: Re: which one is faster
Date: 2010-10-26 12:08:37
Message-ID: AANLkTinuLB_oZfFT17irk3OH-0q=QJnCpYWN6PED0LRY@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

implementation wise, count(*) is faster. Very easy to test:

SELECT COUNT(*) FROM generate_series(1,100) a, generate_series(1,1000) b;

SELECT COUNT(a) FROM generate_series(1,100) a, generate_series(1,1000) b;

;]

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Szymon Guz 2010-10-26 12:16:31 Re: which one is faster
Previous Message Szymon Guz 2010-10-26 12:05:36 Re: which one is faster