Please #PostgreSQL hackers, we'd like to understand the significant performance difference between count(*) and count(1).https://twitter.com/lukaseder/status/1174621016187973632 …
Did you compile with the --with-llvm option? (you can check via select setting from pg_config where name='CONFIGURE';) What are your actual timings for the generate_series version of the test?
-
-
No compilation option at all. It's really a "basic" postgres 13 installation. I followed Postgres documentation to compile it.
Thanks. Twitter will use this to make your timeline better. UndoUndo
-
-
-
Also SELECT pg_jit_available();
-
You may have found it. I compiled Postgres 13 without any option. Is it the default ?pic.twitter.com/W224LfbjF9
- 1 more reply
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.