Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit4c83e59

Browse files
committed
Increase size of shared memory for pg_commit_ts
Like5364b35 did for pg_commit, change the formula used todetermine number of pg_commit_ts buffers, which helps performance withlarger servers.Discussion:https://postgr.es/m/20210115220744.GA24457@alvherre.pgsqlReviewed-by: Noah Misch <noah@leadboat.com>Reviewed-by: Tomas Vondra <tomas.vondra@enterprisedb.com>
1 parente712254 commit4c83e59

File tree

1 file changed

+4
-3
lines changed

1 file changed

+4
-3
lines changed

‎src/backend/access/transam/commit_ts.c

Lines changed: 4 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -508,13 +508,14 @@ pg_xact_commit_timestamp_origin(PG_FUNCTION_ARGS)
508508
/*
509509
* Number of shared CommitTS buffers.
510510
*
511-
* We use a very similar logic as for the number of CLOG buffers; see comments
512-
* in CLOGShmemBuffers.
511+
* We use a very similar logic as for the number of CLOG buffers (except we
512+
* scale up twice as fast with shared buffers, and the maximum is twice as
513+
* high); see comments in CLOGShmemBuffers.
513514
*/
514515
Size
515516
CommitTsShmemBuffers(void)
516517
{
517-
returnMin(16,Max(4,NBuffers /1024));
518+
returnMin(256,Max(4,NBuffers /256));
518519
}
519520

520521
/*

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp