lorre takes a very long time to sync less than 10k blocks

[leenpaws]

Upon initial deployment, despite best efforts to lower the number of blocks that need to by sync'ed, Lorre takes upwards of 6 minutes on the following queries: SELECT COUNT(*) FROM (SELECT DISTINCT operation_group_hash FROM tezos.balance_updates) AS temp

SELECT COUNT(*) FROM (SELECT DISTINCT hash FROM tezos.operation_groups) AS temp and SELECT COUNT(*) FROM (SELECT DISTINCT signature FROM tezos.operation_groups) AS temp

[leenpaws]

Adding hash as an index, adding signature as index

[ivanopagano]

Adding hash as an index, adding signature as index

Does this reduce the measured time?