Re: dump_all/restore times?

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