diff options
| author | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2021-11-30 14:29:31 -0300 |
|---|---|---|
| committer | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2021-11-30 14:29:31 -0300 |
| commit | 4c83e59e01a89b0b19245b8e0317d87ae60226eb (patch) | |
| tree | c805dea8cd1415b358cb15a84410c89a6153e8fa /src/backend/access/transam/commit_ts.c | |
| parent | e7122548a3f754060db1767582148b3559fe8d43 (diff) | |
| download | postgresql-4c83e59e01a89b0b19245b8e0317d87ae60226eb.tar.gz postgresql-4c83e59e01a89b0b19245b8e0317d87ae60226eb.zip | |
Increase size of shared memory for pg_commit_ts
Like 5364b357fb11 did for pg_commit, change the formula used to
determine number of pg_commit_ts buffers, which helps performance with
larger servers.
Discussion: https://postgr.es/m/20210115220744.GA24457@alvherre.pgsql
Reviewed-by: Noah Misch <noah@leadboat.com>
Reviewed-by: Tomas Vondra <tomas.vondra@enterprisedb.com>
Diffstat (limited to 'src/backend/access/transam/commit_ts.c')
| -rw-r--r-- | src/backend/access/transam/commit_ts.c | 7 |
1 files changed, 4 insertions, 3 deletions
diff --git a/src/backend/access/transam/commit_ts.c b/src/backend/access/transam/commit_ts.c index 42ea8e53f2c..cbbe19fea83 100644 --- a/src/backend/access/transam/commit_ts.c +++ b/src/backend/access/transam/commit_ts.c @@ -508,13 +508,14 @@ pg_xact_commit_timestamp_origin(PG_FUNCTION_ARGS) /* * Number of shared CommitTS buffers. * - * We use a very similar logic as for the number of CLOG buffers; see comments - * in CLOGShmemBuffers. + * We use a very similar logic as for the number of CLOG buffers (except we + * scale up twice as fast with shared buffers, and the maximum is twice as + * high); see comments in CLOGShmemBuffers. */ Size CommitTsShmemBuffers(void) { - return Min(16, Max(4, NBuffers / 1024)); + return Min(256, Max(4, NBuffers / 256)); } /* |