Postgres Pro
Downloads
Home   >   mailing lists

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

From Szymon Guz
Subject Re: which one is faster
Date
Msg-id AANLkTi=sidQSMAPNVJF9_EJ7xUiNX65ujsSXb9mF9RhN@mail.gmail.com
Whole thread Raw
In response to Re: which one is faster  (Grzegorz Jaśkiewicz <gryzman@gmail.com>)
Responses Re: which one is faster
List pgsql-performance
Tree view
2010/10/26 Grzegorz Jaśkiewicz <gryzman@gmail.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?


pgsql-performance by date:

Previous
From: Grzegorz Jaśkiewicz
Date:
Subject: Re: which one is faster
Next
From: Grzegorz Jaśkiewicz
Date:
Subject: Re: which one is faster