diff options
| author | Toni Spets <toni.spets@iki.fi> | 2021-08-02 16:24:43 +0300 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2021-08-02 13:24:43 +0000 |
| commit | ba5287f5e8be150551824493b3ad685dde00a543 (patch) | |
| tree | cb8b765fa310c52e4c84a704327b38fe3055891a /docs/sample_config.yaml | |
| parent | Fix deb build script to set prerelease flag correctly (#10500) (diff) | |
| download | synapse-ba5287f5e8be150551824493b3ad685dde00a543.tar.xz | |
Allow setting transaction limit for db connections (#10440)
Setting the value will help PostgreSQL free up memory by recycling the connections in the connection pool. Signed-off-by: Toni Spets <toni.spets@iki.fi>
Diffstat (limited to 'docs/sample_config.yaml')
| -rw-r--r-- | docs/sample_config.yaml | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/docs/sample_config.yaml b/docs/sample_config.yaml index 853c2f6899..1a217f35db 100644 --- a/docs/sample_config.yaml +++ b/docs/sample_config.yaml @@ -720,6 +720,9 @@ caches: # 'name' gives the database engine to use: either 'sqlite3' (for SQLite) or # 'psycopg2' (for PostgreSQL). # +# 'txn_limit' gives the maximum number of transactions to run per connection +# before reconnecting. Defaults to 0, which means no limit. +# # 'args' gives options which are passed through to the database engine, # except for options starting 'cp_', which are used to configure the Twisted # connection pool. For a reference to valid arguments, see: @@ -740,6 +743,7 @@ caches: # #database: # name: psycopg2 +# txn_limit: 10000 # args: # user: synapse_user # password: secretpassword |