Is there ever a case where `SELECT COUNT(*)` would return a different result in `SELECT COUNT(something)` assuming no group by clause? I'm curious why they generate different query plans on virtually every backend.
-
What I think is going on is that the select(id) needs to examine data inside each row, where as count(*) only needs to know the rows existence
I'm more interested in the difference between count(*) and count(table.*) or count((some, column, list))
-
-
I'll try experimenting with a few different queries, since I have PG admin open.
-
Well this is interesting. For select(table.*) plan with is 5676 in my case. Query is taking around 213 ms.
- 4 more replies
New conversation -
Loading seems to be taking a while.
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.