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 |
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? |