[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
|Fix Version/s:||PDB 3.2.2|
|Remaining Estimate:||Not Specified|
|Time Spent:||Not Specified|
|Original Estimate:||Not Specified|
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.