Jira (PDB-5647) Slow fact queries after PuppetDB 7 upgrade (comparing with PuppetDB 5) with GCP CloudSQL PostgreSQL

['Krzysztof Krzyżaniak' via Puppet Bugs]

Title: Message Title

Krzysztof Krzyżaniak commented on PDB-5647   Re: Slow fact queries after PuppetDB 7 upgrade (comparing with PuppetDB 5) with GCP CloudSQL PostgreSQL It looks like it's entirely connected with the PostgreSQL version, all versions higher than 9 have problems with that query. These are times we gathered for various combination of PuppetDB and PostgreSQL (in any case JIT is switched off): puppetdb5 & PostgreSQL13 real 0m24.315s user 0m0.006s puppetdb5 & PostgreSQL9.6  real 0m7.194s user 0m0.004s puppetdb 7.12.0 & PostgreSQL9.6 real 0m5.689s user 0m0.005s puppetdb 7.13.0 & PostgreSQL13 - combination not possible, doesn't work. Add Comment   This message was sent by Atlassian Jira (v8.20.21#820021-sha1:38274c8) -- You received this message because you are subscribed to the Google Groups "Puppet Bugs" group. To unsubscribe from this group and stop receiving emails from it, send an email to puppet-bugs+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/puppet-bugs/JIRA.486416.1685707350000.6880.1686575700044%40Atlassian.JIRA.