|
1 | 1 | <!-- |
2 | | -$Header: /cvsroot/pgsql/doc/src/sgml/runtime.sgml,v 1.165 2002/12/27 14:06:34 momjian Exp $ |
| 2 | +$Header: /cvsroot/pgsql/doc/src/sgml/runtime.sgml,v 1.166 2003/01/11 05:04:14 momjian Exp $ |
3 | 3 | --> |
4 | 4 |
|
5 | 5 | <Chapter Id="runtime"> |
@@ -380,11 +380,12 @@ FATAL 1: ShmemCreate: cannot create region |
380 | 380 | <screen> |
381 | 381 | IpcSemaphoreCreate: semget(key=5440026, num=16, 01600) failed: No space left on device |
382 | 382 | </screen> |
383 | | - does <emphasis>not</emphasis> mean you've run out of disk space. It |
384 | | - means your kernel's limit on the number of System V semaphores is |
385 | | - smaller than the number <productname>PostgreSQL</productname> wants |
386 | | - to create. As above, you may be able to work around the problem by |
387 | | - starting the postmaster with a reduced number of allowed connections |
| 383 | + does <emphasis>not</emphasis> mean you've run out of disk |
| 384 | + space. It means your kernel's limit on the number of <systemitem |
| 385 | + class="osname">System V</> semaphores is smaller than the number |
| 386 | + <productname>PostgreSQL</productname> wants to create. As above, |
| 387 | + you may be able to work around the problem by starting the |
| 388 | + postmaster with a reduced number of allowed connections |
388 | 389 | (<option>-N</option> switch), but you'll eventually want to |
389 | 390 | increase the kernel limit. |
390 | 391 | </para> |
@@ -1838,8 +1839,21 @@ dynamic_library_path = '/usr/local/lib/postgresql:/home/my_project/lib:$libdir' |
1838 | 1839 | <listitem> |
1839 | 1840 | <para> |
1840 | 1841 | Sets the number of shared memory buffers used by the database |
1841 | | - server. The default is 64. Each buffer is typically 8192 bytes. |
1842 | | - This option can only be set at server start. |
| 1842 | + server. The default is 64. Each buffer is typically 8192 |
| 1843 | + bytes. This must be greater than 16, as well as at least twice |
| 1844 | + the value of <varname>MAX_CONNECTIONS</varname>; however, a |
| 1845 | + higher value can often improve performance on modern |
| 1846 | + machines. Values of at least a few thousand are recommended |
| 1847 | + for production installations. This option can only be set at |
| 1848 | + server start. |
| 1849 | + </para> |
| 1850 | + |
| 1851 | + <para> |
| 1852 | + Increasing this parameter may cause <productname>PostgreSQL</> |
| 1853 | + to request more <systemitem class="osname">System V</> shared |
| 1854 | + memory than your operating system's default configuration |
| 1855 | + allows. See <xref linkend="sysvipc"> for information on how to |
| 1856 | + adjust these parameters, if necessary. |
1843 | 1857 | </para> |
1844 | 1858 | </listitem> |
1845 | 1859 | </varlistentry> |
@@ -2165,8 +2179,9 @@ dynamic_library_path = '/usr/local/lib/postgresql:/home/my_project/lib:$libdir' |
2165 | 2179 | <term><varname>WAL_BUFFERS</varname> (<type>integer</type>)</term> |
2166 | 2180 | <listitem> |
2167 | 2181 | <para> |
2168 | | - Number of disk-page buffers in shared memory for WAL logging. |
2169 | | -This option can only be set at server start. |
| 2182 | + Number of disk-page buffers in shared memory for WAL |
| 2183 | + logging. The default is 4. This option can only be set at |
| 2184 | + server start. |
2170 | 2185 | </para> |
2171 | 2186 | </listitem> |
2172 | 2187 | </varlistentry> |
|