Re: dump_all/restore times? - Mailing list pgsql-general

From nolan@celery.tssi.com
Subject Re: dump_all/restore times?
Date
Msg-id 20030723075229.22738.qmail@celery.tssi.com
Whole thread Raw
In response to Re: dump_all/restore times?  (Kaarel <kaarel@future.ee>)
Responses Re: dump_all/restore times?  (Kaarel <kaarel@future.ee>)
Re: dump_all/restore times?  (Kaarel <kaarel@future.ee>)
List pgsql-general
> 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.

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.
--
Mike Nolan

pgsql-general by date:

Previous
From: Kaarel
Date:
Subject: Re: dump_all/restore times?
Next
From: "Nigel J. Andrews"
Date:
Subject: Re: 0/1 vs true/false