costap
10/25/2021, 9:59 AMspicedb=> SELECT MIN(id), MAX(id) FROM relation_tuple_transaction WHERE timestamp >= '2021-10-24T09:38:54.987366Z';
min | max
-----+-----
|
(1 row)
Time: 8303.089 ms (00:08.303)
spicedb=> CREATE INDEX idx_relation_tuple_transaction_timestamp on relation_tuple_transaction(timestamp);
CREATE INDEX
Time: 5283.843 ms (00:05.284)
spicedb=> SELECT MIN(id), MAX(id) FROM relation_tuple_transaction WHERE timestamp >= '2021-10-24T09:38:54.987366Z';
min | max
-----+-----
|
(1 row)
Time: 1.142 ms
Much better 🙂