Jira (PDB-4874) regression on resource query performance on upgrade to 6.11.3 from 5.1

[Julian Taylor (Jira)]

Title: Message Title

Julian Taylor commented on PDB-4874   Re: regression on resource query performance on upgrade to 6.11.3 from 5.1 It appears running a ANALYZE on the resource_params table helped postgres to generate a good plan with default settings. The query is now down to 90ms. So this is probably no regression, just an issue with poor statistics in the database (due to it being initialized from scratch) causing the postgres planner to create a bad plan. Add Comment   This message was sent by Atlassian Jira (v8.5.2#805002-sha1:a66f935) -- 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.370482.1598537549000.25913.1598615520023%40Atlassian.JIRA.