[PDB-4512] See if we can drop joins that a query doesn't need in some cases - Puppet Jira Server

XML

Word

Printable

Release Notes:
New Feature
Release Notes Summary:

Hide
PuppetDB now has an experimental query optimizer (link to api/query/v4/query#experimental_query_optimization) that may be able to
substantially decrease the cost (and correspondingly decrease the
response time) of some queries. (~~PDB-4512~~)

Show
PuppetDB now has an experimental query optimizer (link to api/query/v4/query#experimental_query_optimization) that may be able to substantially decrease the cost (and correspondingly decrease the response time) of some queries. ( PDB-4512 )

It looks like this may dramatically speed up some queries (and correspondingly decrease the load on pg), but there are plenty of questions.