Postgres Pro
Downloads
Home   >   mailing lists

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

From Grzegorz Jaśkiewicz
Subject Re: which one is faster
Date
Msg-id AANLkTinuLB_oZfFT17irk3OH-0q=QJnCpYWN6PED0LRY@mail.gmail.com
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 
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;


;]

pgsql-performance by date:

Previous
From: Szymon Guz
Date:
Subject: Re: which one is faster
Next
From: Szymon Guz
Date:
Subject: Re: which one is faster