From e2a932ec0b4b1568b48726c9a855485f596d07ce Mon Sep 17 00:00:00 2001 From: Neil Alexander Date: Tue, 10 May 2022 11:23:36 +0100 Subject: Add indexes to `syncapi_output_room_events` table that satisfy the filters (#2446) --- syncapi/storage/postgres/output_room_events_table.go | 5 +++++ 1 file changed, 5 insertions(+) (limited to 'syncapi/storage/postgres') diff --git a/syncapi/storage/postgres/output_room_events_table.go b/syncapi/storage/postgres/output_room_events_table.go index 17e2feab..d84d0cfa 100644 --- a/syncapi/storage/postgres/output_room_events_table.go +++ b/syncapi/storage/postgres/output_room_events_table.go @@ -69,6 +69,11 @@ CREATE TABLE IF NOT EXISTS syncapi_output_room_events ( -- were emitted. exclude_from_sync BOOL DEFAULT FALSE ); + +CREATE INDEX IF NOT EXISTS syncapi_output_room_events_type_idx ON syncapi_output_room_events (type); +CREATE INDEX IF NOT EXISTS syncapi_output_room_events_sender_idx ON syncapi_output_room_events (sender); +CREATE INDEX IF NOT EXISTS syncapi_output_room_events_room_id_idx ON syncapi_output_room_events (room_id); +CREATE INDEX IF NOT EXISTS syncapi_output_room_events_exclude_from_sync_idx ON syncapi_output_room_events (exclude_from_sync); ` const insertEventSQL = "" + -- cgit v1.2.3