Extra not required indices?
Opened this issue · 0 comments
fanatid commented
I was looked on PostgreSQL schema and my eyes catched a few indices.
solana-accountsdb-connector/connector-raw/scripts/create_schema.sql
Lines 63 to 66 in c18632c
It looks like
PRIMARY KEY
can be replaced by CREATE UNIQUE INDEX account_write_searchkey
.Not sure about index
account_write_pubkey_id_idx
too, does it make sense to have it while we already have account_write_searchkey
? Some queries are more efficient with pubkey index only?