Re: which one is faster

From: Szymon Guz <mabewlun(at)gmail(dot)com>
To: Grzegorz Jaśkiewicz <gryzman(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:16:31
Message-ID: AANLkTi=sidQSMAPNVJF9_EJ7xUiNX65ujsSXb9mF9RhN@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

2010/10/26 Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>

> 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;
>
>
> ;]
>

Well, strange. Why is that slower?

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Grzegorz Jaśkiewicz 2010-10-26 12:20:33 Re: which one is faster
Previous Message Grzegorz Jaśkiewicz 2010-10-26 12:08:37 Re: which one is faster