[PDB-2206] indexes on transaction_uuid and hash are not used in querying Created: 2015/11/19  Updated: 2015/12/02  Resolved: 2015/11/25

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

Type: Bug Priority: Normal
Reporter: Wyatt Alt Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Story Points: 2
Sprint: PuppetDB 2015-12-02


We should either flip them back to an indexed varchar 40, or munge hashes to bytea on the RHS of the equality comparison. We should probably just pick whatever approach is fastest, since this directly influences speed of syncing and the storage benefits of bytea are probably insignificant compared to the kind of json storage we've been adopting.

Generated at Sat Feb 29 04:57:10 PST 2020 using Jira 8.5.2#805002-sha1:a66f9354b9e12ac788984e5d84669c903a370049.