Hacker News new | ask | show | jobs
by Sesse__ 862 days ago
FWIW, I've seen planning+query times triple with JIT on, with no partitioned tables involved. It just takes forever to JIT sometimes. (This was with Postgres 13 and 14, IIRC.)

Update: I checked some old IRC logs, and found a query that took 1476 ms without JIT and 8754 ms with JIT on. And that is execution time, not planning time!
1 comments
davidrowley 862 days ago
Was there an indication of the number of functions compiled? There is work ongoing in this area, so feedback on this topic is very welcome on the PostgreSQL mailing lists.
link
Sesse__ 862 days ago
Not that I can remember, no. I don't have the details anymore; I delegated it to others to report to -perform, and then they never did. :-)
link