Please #PostgreSQL hackers, we'd like to understand the significant performance difference between count(*) and count(1).https://twitter.com/lukaseder/status/1174621016187973632 …
Was JIT enabled and was it used for this query? Because in my tests that seems to make a big difference.
-
-
As the jit value default is on for postgres 13, I assume it is enabled, but I'll check.
-
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
- 5 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.