diff options
| author | Erik Johnston <erik@matrix.org> | 2015-07-02 13:18:41 +0100 |
|---|---|---|
| committer | Erik Johnston <erik@matrix.org> | 2015-07-02 13:18:41 +0100 |
| commit | ac78e60de6fd2e409d6abd806e8850d539bbe644 (patch) | |
| tree | ff048af0f020b4f2e2c7560f863b8f2aa99fc158 /synapse/storage | |
| parent | Consolidate duplicate code in notifier (diff) | |
| download | synapse-ac78e60de6fd2e409d6abd806e8850d539bbe644.tar.xz | |
Add stream_id index
Diffstat (limited to 'synapse/storage')
| -rw-r--r-- | synapse/storage/schema/delta/21/receipts.sql | 6 |
1 files changed, 5 insertions, 1 deletions
diff --git a/synapse/storage/schema/delta/21/receipts.sql b/synapse/storage/schema/delta/21/receipts.sql index ccd64ec7f4..ac7738e371 100644 --- a/synapse/storage/schema/delta/21/receipts.sql +++ b/synapse/storage/schema/delta/21/receipts.sql @@ -33,6 +33,10 @@ CREATE TABLE IF NOT EXISTS receipts_linearized ( event_id TEXT NOT NULL ); -CREATE INDEX receipts_linearized_room_tuple ON receipts_graph( +CREATE INDEX receipts_linearized_room_tuple ON receipts_linearized( room_id, receipt_type, user_id ); + +CREATE INDEX receipts_linearized_id ON receipts_linearized( + stream_id +); |