Jira (PDB-4512) See if we can drop joins that a query doesn't need in some cases

[Rob Browning (JIRA)]

Rob Browning created an issue

PuppetDB / PDB-4512 See if we can drop joins that a query doesn't need in some cases Issue Type: Improvement Assignee: Unassigned Created: 2019/09/24 9:42 AM Priority: Normal Reporter: Rob Browning It looks like this may dramatically speed up some queries (and correspondingly decrease the load on pg), but there are plenty of questions. Add Comment

This message was sent by Atlassian JIRA (v7.7.1#77002-sha1:e75ca93)

[Rob Browning (JIRA)]

Rob Browning assigned an issue to Rob Browning

PuppetDB / PDB-4512 See if we can drop joins that a query doesn't need in some cases

Change By: Rob Browning Assignee: Rob Browning

Add Comment

[Zachary Kent (JIRA)]

Zachary Kent updated an issue

PuppetDB / PDB-4512 See if we can drop joins that a query doesn't need in some cases

Change By: Zachary Kent Fix Version/s: PDB 6.9.0

Add Comment

[Rob Browning (JIRA)]

Rob Browning updated an issue

PuppetDB / PDB-4512 See if we can drop joins that a query doesn't need in some cases

Change By: Rob Browning Release Notes Summary: 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) Release Notes: New Feature

Add Comment

[Heston Hoffman (JIRA)]

Heston Hoffman updated an issue

PuppetDB / PDB-4512 See if we can drop joins that a query doesn't need in some cases

Change By: Heston Hoffman Labels: resolved-issue-added

Add Comment