I have added a mention of sort_mem in the restore docs --- patch
attached.
---------------------------------------------------------------------------
Vivek Khera wrote:
> >>>>> "BM" == Bruce Momjian <pgman@candle.pha.pa.us> writes:
>
> BM> Vivek Khera wrote:
> >> >>>>> "BM" == Bruce Momjian <pgman@candle.pha.pa.us> writes:
> >>
> BM> Here is an applied patch that suggests increasing sort_mem during
> BM> restore. I though of putting it near the database restore section or in
> BM> the manual, but is seemed more centralized to put it near the actual
> BM> parameter.
> >>
> >> But nobody will find it there...
>
> BM> OK, then where should I put it?
>
>
> In the section describing how to do a restore. I'd be reading that as
> opposed to the section that describes tuning the server.
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
Index: doc/src/sgml/backup.sgml
===================================================================
RCS file: /cvsroot/pgsql-server/doc/src/sgml/backup.sgml,v
retrieving revision 2.27
diff -c -c -r2.27 backup.sgml
*** doc/src/sgml/backup.sgml 1 Aug 2003 01:01:52 -0000 2.27
--- doc/src/sgml/backup.sgml 17 Aug 2003 03:11:24 -0000
***************
*** 153,158 ****
--- 153,162 ----
</para>
</important>
+ <tip>
+ Restore performance can be improved by increasing <literal>SORT_MEM</>
+ (see <xref linkend="runtime-config-resource-memory">).
+ </tip>
</sect2>
<sect2 id="backup-dump-all">
