<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=ISO-8859-1">
<title></title>
</head>
<body>
<br>
<blockquote type="cite"
cite="mid20030723075229(dot)22738(dot)qmail(at)celery(dot)tssi(dot)com">
<blockquote type="cite">
<pre wrap="">I was thinking the very same thing. If it is a must to always bump up
sort_mem before running restore why can't the restore utility do it?
Take a portion of the currently available memory or ask a user
interactively etc.
</pre>
</blockquote>
<pre wrap=""><!---->
This would need to be a command line option, because there may be systems
on which bumping up sort_mem should not be done, for reasons unrelated to
performance during the restore, and the restore may not always be done
interactively.
</pre>
</blockquote>
<br>
If this can not be done then at least the sort_mem thing should be
mentioned in Chapter 9. Backup and Restore in the PostgreSQL
Administrator's Guide.
<a class="moz-txt-link-freetext" href="http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html#sortmem">http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html#sortmem</a>
too only slightly mentiones data dumps as opposed to "before running
the restore" suggested by Tom.<br>
<br>
Kaarel<br>
</body>
</html>