|
1 | 1 | <!-- |
2 | | -$PostgreSQL: pgsql/doc/src/sgml/config.sgml,v 1.16 2005/09/1301:51:18 alvherre Exp $ |
| 2 | +$PostgreSQL: pgsql/doc/src/sgml/config.sgml,v 1.17 2005/09/1315:24:56 neilc Exp $ |
3 | 3 | --> |
4 | 4 | <chapter Id="runtime-config"> |
5 | 5 | <title>Run-time Configuration</title> |
@@ -1715,20 +1715,20 @@ archive_command = 'copy "%p" /mnt/server/archivedir/"%f"' # Windows |
1715 | 1715 | <para> |
1716 | 1716 | Sets the planner's assumption about the effective size of the |
1717 | 1717 | disk cache that is available to a single index scan. This is |
1718 | | - factored into estimates of the cost of using an index; a higher |
1719 | | - value makes it more likely index scans will be used, a lower |
1720 | | - value makes it more likely sequential scans will be used. When |
1721 | | - setting this parameter you should consider both |
| 1718 | + factored into estimates of the cost of using an index; a |
| 1719 | +highervalue makes it more likely index scans will be used, a |
| 1720 | +lowervalue makes it more likely sequential scans will be |
| 1721 | +used. Whensetting this parameter you should consider both |
1722 | 1722 | <productname>PostgreSQL</productname>'s shared buffers and the |
1723 | 1723 | portion of the kernel's disk cache that will be used for |
1724 | | - <productname>PostgreSQL</productname> data files. Also, take into |
1725 | | - account the expected number of concurrent queries using different |
1726 | | - indexes, since they will have to share the available space. |
1727 | | - This parameter has no effect on the size of shared memory |
1728 | | - allocated by PostgreSQL, nor does it reserve kernel disk cache; |
1729 | | - it is used only for estimation purposes. |
1730 | | - The value is measured in disk pages, which are |
1731 | | - normally 8192 bytes each. The default is 1000. |
| 1724 | + <productname>PostgreSQL</productname> data files. Also, take |
| 1725 | +intoaccount the expected number of concurrent queries using |
| 1726 | +differentindexes, since they will have to share the available |
| 1727 | +space.This parameter has no effect on the size of shared |
| 1728 | +memoryallocated by<productname>PostgreSQL</productname>, nor |
| 1729 | +doesitreserve kernel disk cache; itis used only for |
| 1730 | +estimation purposes.The value is measured in disk pages, |
| 1731 | +which arenormally 8192 bytes each. The default is 1000. |
1732 | 1732 | </para> |
1733 | 1733 | </listitem> |
1734 | 1734 | </varlistentry> |
@@ -3662,7 +3662,8 @@ dynamic_library_path = 'C:\tools\postgresql;H:\my_project\lib;$libdir' |
3662 | 3662 | determines whether OIDs will be included in tables created by |
3663 | 3663 | <command>SELECT INTO</command>. In <productname>PostgreSQL</> |
3664 | 3664 | 8.1 <varname>default_with_oids</> is disabled by default; in |
3665 | | - prior versions of PostgreSQL, it was on by default. |
| 3665 | + prior versions of <productname>PostgreSQL</productname>, it |
| 3666 | + was on by default. |
3666 | 3667 | </para> |
3667 | 3668 |
|
3668 | 3669 | <para> |
|