From dd8cbf08bac0e69f1caf00ec1efec6019eb36c29 Mon Sep 17 00:00:00 2001 From: DMRobertson Date: Tue, 10 Jan 2023 12:19:38 +0000 Subject: deploy: 9a4c69f59f1ac54838d3b0f47280d858b7e41073 --- .../administration/database_maintenance_tools.html | 201 +++++++++++++++++++++ 1 file changed, 201 insertions(+) create mode 100644 v1.75/usage/administration/database_maintenance_tools.html (limited to 'v1.75/usage/administration/database_maintenance_tools.html') diff --git a/v1.75/usage/administration/database_maintenance_tools.html b/v1.75/usage/administration/database_maintenance_tools.html new file mode 100644 index 0000000000..1636d7239d --- /dev/null +++ b/v1.75/usage/administration/database_maintenance_tools.html @@ -0,0 +1,201 @@ + + + + + + Database Maintenance Tools - Synapse + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
+ +
+ + + + + + + +
+
+ +
+ +
+ +

This blog post by Victor Berger explains how to use many of the tools listed on this page: https://levans.fr/shrink-synapse-database.html

+

List of useful tools and scripts for maintenance Synapse database:

+

Purge Remote Media API

+

The purge remote media API allows server admins to purge old cached remote media.

+

Purge Local Media API

+

This API deletes the local media from the disk of your own server.

+

Purge History API

+

The purge history API allows server admins to purge historic events from their database, reclaiming disk space.

+

synapse-compress-state

+

Tool for compressing (deduplicating) state_groups_state table.

+

SQL for analyzing Synapse PostgreSQL database stats

+

Some easy SQL that reports useful stats about your Synapse database.

+ +
+ + +
+
+ + + +
+ + + + + + + + + + + + + \ No newline at end of file -- cgit 1.5.1