# PostgreSQL performance as of version 12

**URL:** <https://forum.reportserver.net/t/postgresql-performance-as-of-version-12/1435>\
**Category:** ReportServer (EN)\
**Created:** [April 15, 2021, 12:52pm UTC](https://forum.reportserver.net/t/postgresql-performance-as-of-version-12/1435 "2021-04-15T12:52:47Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![IF\_Eduardo](https://forum.reportserver.net/letter_avatar_proxy/v4/letter/i/94ad74/32.png) [@IF\_Eduardo](https://forum.reportserver.net/u/IF_Eduardo)\
**Post date:** [April 15, 2021, 12:52pm UTC](https://forum.reportserver.net/t/postgresql-performance-as-of-version-12/1435/1 "2021-04-15T12:52:47Z")

</div>

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](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/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](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](https://severalnines.com/database-blog/overview-just-time-compilation-jit-postgresql)