[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

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

 Description   

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 Thu Nov 21 02:40:40 PST 2019 using JIRA 7.7.1#77002-sha1:e75ca93d5574d9409c0630b81c894d9065296414.