[PDB-1225] Update fact storage and querying to use the new path column in the facts table Created: 2015/02/10  Updated: 2015/05/05  Resolved: 2015/03/30

Status: Closed
Project: PuppetDB
Component/s: None
Affects Version/s: None
Fix Version/s: PDB 2.3.1

Type: Bug Priority: Normal
Reporter: Ryan Senior Assignee: Rob Browning
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
relates to PDB-1031 ERROR: update or delete on table "fac... Closed
relates to PDB-1224 Move fact path reference from the fac... Closed
Story Points: 1
Sprint: PuppetDB 2015-02-25, PuppetDB 2015-03-11, PuppetDB 2015-03-25, PuppetDB 2015-04-08
QA Contact: Kurt Wall


In storage.clj we should be able to diff fact paths like we currently diff fact values. As part of this the delete queries can change to use the new column, which should be significantly faster.

The query engine and existing endpoints will also likely need to be updated to reflect the new structure.

QA Risk Assessment

Probability Low (not a user-visible change)
Impact Med (would not be catastrophic)
Risk Level Low

Comment by Ryan Senior [ 2015/02/27 ]

There's two pieces to this, updating storage and updating queries. I can't test this (unless I dummy a bunch of data) until the storage is done, but there's a commit here with the changes we'll need on the query side.

Generated at Sat Jul 11 11:47:10 PDT 2020 using Jira 8.5.2#805002-sha1:a66f9354b9e12ac788984e5d84669c903a370049.