diff options
| author | Erik Johnston <erik@matrix.org> | 2015-04-15 11:43:25 +0100 |
|---|---|---|
| committer | Erik Johnston <erik@matrix.org> | 2015-04-15 11:43:25 +0100 |
| commit | cce5d057d34ac6fc953d1987bbce3bce2ce42bd8 (patch) | |
| tree | 562e2e441bb6bca2694eb76578f46827749a68e8 /synapse/storage/schema/delta | |
| parent | Merge branch 'develop' of github.com:matrix-org/synapse into postgres (diff) | |
| download | synapse-cce5d057d34ac6fc953d1987bbce3bce2ce42bd8.tar.xz | |
Add index on events (topological_ordering, stream_ordering) to help with ORDER BY clauses
Diffstat (limited to 'synapse/storage/schema/delta')
| -rw-r--r-- | synapse/storage/schema/delta/16/events_order_index.sql | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/synapse/storage/schema/delta/16/events_order_index.sql b/synapse/storage/schema/delta/16/events_order_index.sql new file mode 100644 index 0000000000..c015414663 --- /dev/null +++ b/synapse/storage/schema/delta/16/events_order_index.sql @@ -0,0 +1 @@ +CREATE INDEX events_order ON events (topological_ordering, stream_ordering); \ No newline at end of file |