Jira (PDB-5450) Slow fact queries after PuppetDB 7.9.0 upgrade when using Postgres 12 with jit enabled

[David McTavish (Jira)]

David McTavish updated an issue

PuppetDB / PDB-5450 Slow fact queries after PuppetDB 7.9.0 upgrade when using Postgres 12 with jit enabled Change By: David McTavish Summary: Slow fact queries after PuppetDB 7.9.0 upgrade when using Postgres 12 with jit enabled Add Comment

This message was sent by Atlassian Jira (v8.20.2#820002-sha1:829506d)

[Elof Ofel (Jira)]

Elof Ofel commented on PDB-5450

Re: Slow fact queries after PuppetDB 7.9.0 upgrade when using Postgres 12 with jit enabled Dito. Thanks for swift and detailed responses. I can't say for sure. I haven't really paid any attentien to the loading time of the dashboard until it took 40 seconds. But no, I would not say it is noticeably slower.

Add Comment

[Austin Blatt (Jira)]

Austin Blatt updated an issue

PuppetDB / PDB-5450

Slow fact queries after PuppetDB 7.9.0 upgrade when using Postgres 12 with jit enabled

Change By: Austin Blatt Affects Version/s: PDB 6.20.0

Add Comment

[David McTavish (Jira)]

David McTavish updated an issue

PuppetDB / PDB-5450 Slow fact queries after PuppetDB 7.9.0 upgrade when using Postgres 12 with jit enabled

Change By: David McTavish Method Found: Needs Assessment Customer Feedback

Add Comment

[Austin Blatt (Jira)]

Austin Blatt commented on PDB-5450

Re: Slow fact queries after PuppetDB 7.9.0 upgrade when using Postgres 12 with jit enabled A known issue (and link from the release note) has been added for this change. https://puppet.com/docs/puppetdb/6/known_issues.html

Add Comment

[David McTavish (Jira)]

David McTavish updated an issue

PuppetDB / PDB-5450

Slow fact queries after PuppetDB 7.9.0 upgrade when using Postgres 12 with jit enabled

Change By: David McTavish Sprint: HAHA On Deck, HA 2022-02-16

Add Comment

[David McTavish (Jira)]

David McTavish updated an issue

PuppetDB / PDB-5450 Slow fact queries after PuppetDB 7.9.0 upgrade when using Postgres 12 with jit enabled

Change By: David McTavish Sprint: HAHA On Deck, HA 2022-02-16 , HA 2022-03-02

Add Comment

[Rob Browning (Jira)]

Rob Browning commented on PDB-5450

Re: Slow fact queries after PuppetDB 7.9.0 upgrade when using Postgres 12 with jit enabled For the time being we plan to avoid the issue by disabling the JIT by default for all PuppetDB DB connections via PDB-5652.

Add Comment