NotificationsYou must be signed in to change notification settings
Fork6
Star31

Commit4c83e59

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 commit4c83e59Copy full SHA for 4c83e59

File tree

1 file changed

-3

lines changed

src/backend/access/transam
- commit_ts.c

1 file changed

-3

lines changed

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

Lines changed: 4 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -508,13 +508,14 @@ pg_xact_commit_timestamp_origin(PG_FUNCTION_ARGS)`
`508`	`508`	`/*`
`509`	`509`	`* Number of shared CommitTS buffers.`
`510`	`510`	`*`
`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.`
`513`	`514`	`*/`
`514`	`515`	`Size`
`515`	`516`	`CommitTsShmemBuffers(void)`
`516`	`517`	`{`
`517`		`-returnMin(16,Max(4,NBuffers /1024));`
	`518`	`+returnMin(256,Max(4,NBuffers /256));`
`518`	`519`	`}`
`519`	`520`
`520`	`521`	`/*`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

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

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commit4c83e59

File tree

1 file changed

1 file changed

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

0 commit comments