Please #PostgreSQL hackers, we'd like to understand the significant performance difference between count(*) and count(1).https://twitter.com/lukaseder/status/1174621016187973632 …
Whether JIT is actually used for a given query depends on plan costs vs. the jit_above_cost settings, so it's worth checking the explain analyze of the test query
-
-
So, here are my `jit` settings. And both explain plans. The planner consider that the costs are the same for both queries and used the same plan for both.pic.twitter.com/oztp4omkiv
-
So JIT is not in play in your test since the costs aren't high enough. How repeatable are your timings? Can you try the generate_series version?
- 3 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.