Jira (PDB-5557) Enable drop-joins for subqueries

Issue Type:	Improvement
Assignee:	Unassigned
Created:	2022/10/24 9:12 AM
Priority:	Normal
Reporter:	Austin Blatt

Drop joins is enabled for top-level queries only. It has been in customers hands for a while now, produced positive performance benefits and very few issues. We should enable it for sub-queries too to see if we can get even more performance benefits from it.

This message was sent by Atlassian Jira (v8.20.11#820011-sha1:0629dd8)

Austin Blatt (Jira)

unread,

Nov 3, 2022, 2:05:03 PM11/3/22

to puppe...@googlegroups.com

Austin Blatt updated an issue

PuppetDB /

Change By:	Austin Blatt
Team:	Skeletor

Cas Donoghue (Jira)

unread,

Nov 3, 2022, 2:40:03 PM11/3/22

to puppe...@googlegroups.com

Cas Donoghue updated an issue

PuppetDB /

Change By:	Cas Donoghue
Story Points:	1

Nick Lewis (Jira)

unread,

Nov 30, 2022, 6:26:02 PM11/30/22

to puppe...@googlegroups.com

Nick Lewis assigned an issue to Nick Lewis

PuppetDB /

Change By:	Nick Lewis
Assignee:	Nick Lewis

Nick Lewis (Jira)

unread,

Nov 30, 2022, 6:26:03 PM11/30/22

to puppe...@googlegroups.com

Nick Lewis updated an issue

PuppetDB /

Change By:	Nick Lewis
Sprint:	Skeletor 12/07/2022

Sean McDonald (Jira)

unread,

Dec 7, 2022, 1:06:02 PM12/7/22

to puppe...@googlegroups.com

Sean McDonald updated an issue

PuppetDB /

Change By:	Sean McDonald
Sprint:	Skeletor 12/07/2022 , Skeletor 12/21/2022

Cas Donoghue (Jira)

unread,

Jan 4, 2023, 1:13:02 PM1/4/23

to puppe...@googlegroups.com

Cas Donoghue updated an issue

PuppetDB /

Change By:	Cas Donoghue
Sprint:	Skeletor 12/07/2022, Skeletor 12/21/2022 , Skeletor 01/18/2023

Cas Donoghue (Jira)

unread,

Jan 18, 2023, 1:25:03 PM1/18/23

to puppe...@googlegroups.com

Cas Donoghue updated an issue

PuppetDB /

Change By:	Cas Donoghue
Sprint:	Skeletor 12/07/2022, Skeletor 12/21/2022, Skeletor 01/18/2023 , Skeletor 02/01/2023

Cas Donoghue (Jira)

unread,

Jan 26, 2023, 5:49:02 PM1/26/23

to puppe...@googlegroups.com

Cas Donoghue updated an issue

PuppetDB /

Change By:	Cas Donoghue
Fix Version/s:	2023.y

Cas Donoghue (Jira)

unread,

Jan 27, 2023, 1:59:03 PM1/27/23

to puppe...@googlegroups.com

Cas Donoghue updated an issue

PuppetDB /

Change By:	Cas Donoghue
Fix Version/s:	2023.y

Fix Version/s:	PDB 8.0.0

Cas Donoghue (Jira)

unread,

Jan 27, 2023, 2:00:05 PM1/27/23

to puppe...@googlegroups.com

Cas Donoghue updated an issue

PuppetDB /

Change By:	Cas Donoghue
Release Notes:	Enhancement
Release Notes Summary:	Drop joins are now applied when evaluating sub queries which should result in performance improvements.