PostgreSQL performance as of version 12

[IF_Eduardo]

As of PostgreSQL 12, jit configuration is turned on by default. Note that this may have large performance drawbacks. You can easily turn this off by PostgreSQL configuration: https://www.postgresql.org/docs/13/runtime-config-query.html

Here you can find some information on this: https://dba.stackexchange.com/questions/257258/upgrade-from-postgres-11-to-postgres-12-made-some-queries-300x-slower-probably

https://dba.stackexchange.com/questions/257759/recursive-cte-based-on-function-values-significantly-slower-on-postgres-12-than/258493

Background information: https://severalnines.com/database-blog/overview-just-time-compilation-jit-postgresql