[Patch] change the default value of shared_buffers in postgresql.conf.sample

From: "zhangjie2(at)fujitsu(dot)com" <zhangjie2(at)fujitsu(dot)com>
To: "pgsql-hackers(at)lists(dot)postgresql(dot)org" <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: [Patch] change the default value of shared_buffers in postgresql.conf.sample
Date: 2021-06-24 06:37:48
Message-ID: TYWPR01MB7678772FD8640C404F1DC882F9079@TYWPR01MB7678.jpnprd01.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi all

In PostgreSQL 14, The default value of shared_buffers is 128MB, but in postgresql.conf.sample, the default value of shared_buffers is 32MB.

I think the following changes should be made.

File: postgresql\src\backend\utils\misc\ postgresql.conf.sample
#shared_buffers = 32MB => #shared_buffers = 128MB

[PostgreSQL 14]
shared_buffers (integer)
Sets the amount of memory the database server uses for shared memory buffers. The default is typically 128 megabytes (128MB)
https://www.postgresql.org/docs/14/runtime-config-resource.html

--------------------------------------------------------------------
In PostgreSQL 9.2, The default value of shared_buffers is 32MB.

[PostgreSQL 9.2]
shared_buffers (integer)
Sets the amount of memory the database server uses for shared memory buffers. The default is typically 32 megabytes (32MB)
https://www.postgresql.org/docs/9.2/runtime-config-resource.html

Here is a patch.

Best Regards!

Attachment Content-Type Size
postgresql.conf.sample.patch application/octet-stream 463 bytes

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message tanghy.fnst@fujitsu.com 2021-06-24 06:40:47 RE: Added schema level support for publication.
Previous Message Michael Paquier 2021-06-24 06:34:26 Re: Can a child process detect postmaster death when in pg_usleep?