https://authzed.com logo
#spicedb
Title
# spicedb
c

costap.

10/25/2021, 9:59 AM
Copy code
spicedb=> 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 🙂