summary refs log tree commit diff
diff options
context:
space:
mode:
-rw-r--r--synapse/storage/schema/delta/40/device_inbox.sql1
1 files changed, 1 insertions, 0 deletions
diff --git a/synapse/storage/schema/delta/40/device_inbox.sql b/synapse/storage/schema/delta/40/device_inbox.sql
index ce58fe2082..b9fe1f0480 100644
--- a/synapse/storage/schema/delta/40/device_inbox.sql
+++ b/synapse/storage/schema/delta/40/device_inbox.sql
@@ -13,6 +13,7 @@
  * limitations under the License.
  */
 
+-- turn the pre-fill startup query into a index-only scan on postgresql.
 INSERT into background_updates (update_name, progress_json)
     VALUES ('device_inbox_stream_index', '{}');