summary refs log tree commit diff
diff options
context:
space:
mode:
authorErik Johnston <erik@matrix.org>2024-05-13 12:32:33 +0100
committerErik Johnston <erik@matrix.org>2024-05-13 13:10:16 +0100
commitb58ed63884d18994b60e6b84b4826befab0a3030 (patch)
tree61e77d24f99e810f3e0434de0f5de0bc30bb26ae
parentDebug logging (diff)
downloadsynapse-b58ed63884d18994b60e6b84b4826befab0a3030.tar.xz
Go faster stripes
-rw-r--r--synapse/storage/databases/main/event_federation.py4
1 files changed, 4 insertions, 0 deletions
diff --git a/synapse/storage/databases/main/event_federation.py b/synapse/storage/databases/main/event_federation.py

index 1f35063e9f..20bc258b75 100644 --- a/synapse/storage/databases/main/event_federation.py +++ b/synapse/storage/databases/main/event_federation.py
@@ -355,6 +355,10 @@ class EventFederationWorkerStore(SignatureWorkerStore, EventsWorkerStore, SQLBas # structuring the recursive part of query to pull out the links without # also returning large quantities of redundant data (which can make it a # lot slower). + + txn.execute("SET LOCAL jit = off") + txn.execute("SET LOCAL enable_seqscan = off") + sql = """ WITH RECURSIVE links(chain_id) AS ( SELECT