From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Kaarel <kaarel(at)future(dot)ee> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: dump_all/restore times? |
Date: | 2003-07-23 20:30:13 |
Message-ID: | 200307232030.h6NKUDG17000@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Here is an applied patch that suggests increasing sort_mem during
restore. I though of putting it near the database restore section or in
the manual, but is seemed more centralized to put it near the actual
parameter.
---------------------------------------------------------------------------
Kaarel wrote:
>
> >>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.
> >
> >
> 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.
> http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html#sortmem too
> only slightly mentiones data dumps as opposed to "before running the
> restore" suggested by Tom.
>
> Kaarel
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
Attachment | Content-Type | Size |
---|---|---|
unknown_filename | text/plain | 1.2 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | scott.marlowe | 2003-07-23 20:32:06 | Re: Join Problem |
Previous Message | Rob Sell | 2003-07-23 20:28:28 | Re: Join Problem |