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

Commit7b130fb

Browse files
committed
Provide better guidance for adjusting shared_buffers.
1 parent961ad3f commit7b130fb

File tree

1 file changed

+27
-4
lines changed

1 file changed

+27
-4
lines changed

‎doc/src/sgml/config.sgml

Lines changed: 27 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,4 @@
1-
<!-- $PostgreSQL: pgsql/doc/src/sgml/config.sgml,v 1.266 2010/04/15 16:25:13 heikki Exp $ -->
1+
<!-- $PostgreSQL: pgsql/doc/src/sgml/config.sgml,v 1.267 2010/04/16 21:46:07 rhaas Exp $ -->
22

33
<chapter Id="runtime-config">
44
<title>Server Configuration</title>
@@ -784,9 +784,32 @@ SET ENABLE_SEQSCAN TO OFF;
784784
This setting must be at least 128 kilobytes. (Non-default
785785
values of <symbol>BLCKSZ</symbol> change the minimum.) However,
786786
settings significantly higher than the minimum are usually needed
787-
for good performance. Several tens of megabytes are recommended
788-
for production installations. This parameter can only be set at
789-
server start.
787+
for good performance. This parameter can only be set at server start.
788+
</para>
789+
790+
<para>
791+
If you have a dedicated database server with 1GB or more of RAM, a
792+
reasonable starting value for <varname>shared_buffers</varname> is 25%
793+
of the memory in your system. There are some workloads where even
794+
large settings for <varname>shared_buffers</varname> are effective, but
795+
because <productname>PostgreSQL</productname> also relies on the
796+
operating system cache, it is unlikely that an allocation of more than
797+
40% of RAM to <varname>shared_buffers</varname> will work better than a
798+
smaller amount. Larger settings for <varname>shared_buffers</varname>
799+
usually require a corresponding increase in
800+
<varname>checkpoint_segments</varname>, in order to spread out the
801+
process of writing large quantities of new or changed data over a
802+
longer period of time.
803+
</para>
804+
805+
<para>
806+
On systems with less than 1GB of RAM, a smaller percentage of RAM is
807+
appropriate, so as to leave adequate space for the operating system.
808+
Also, on Windows, large values for <varname>shared_buffers</varname>
809+
aren't as effective. You may find better results keeping the setting
810+
relatively low and using the operating system cache more instead. The
811+
useful range for <varname>shared_buffers</varname> on Windows systems
812+
is generally from 64MB to 512MB.
790813
</para>
791814

792815
<para>

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp