Uploaded image for project: 'PuppetDB'
  1. PuppetDB
  2. PDB-5452

Disable JIT in query engine

    XMLWordPrintable

Details

    • Task
    • Status: Resolved
    • Normal
    • Resolution: Fixed
    • None
    • PDB 6.21.0, PDB 7.10.0
    • PuppetDB
    • None
    • Enhancement
    • Hide
      PostgreSQL introduced a query JIT in version 11 and enabled it by default in 12, and it has turned out to cause some queries to be dramatically more expensive. PuppetDB was affected by this too, and sohas been adjusted to disable the JIT for all of its queries.
      Show
      PostgreSQL introduced a query JIT in version 11 and enabled it by default in 12, and it has turned out to cause some queries to be dramatically more expensive. PuppetDB was affected by this too, and sohas been adjusted to disable the JIT for all of its queries.
    • Needs Assessment

    Description

      https://tickets.puppetlabs.com/browse/PDB-5450 describes a performance regression when using PDB with Postgres JIT enabled. This started being the default since Postgres 12. With the upcoming upgrade to Postgres 14 in PE, we need to test how JIT performance compares with it turned off.

      In particular, this query is probably a good candidate to start with: https://github.com/puppetlabs/puppetdb/pull/3592

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. PDB-5450 Slow fact queries after PuppetDB 7.9.0 upgrade when using Postgres 12 with jit enabled

          • Normal - Regular issue, some loss of functionality under specific circumstances.
          • Closed

          Activity

            People

              rob.browning Rob Browning
              stel.abrego Stel Abrego
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Zendesk Support