| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Alan Hodgson <ahodgson(at)simkin(dot)ca> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: speed up restore from dump |
| Date: | 2008-10-30 20:17:15 |
| Message-ID: | 20081030201715.GM3857@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Alan Hodgson wrote:
> On Thursday 30 October 2008, Joao Ferreira gmail
> > During restore:
> > # vmstat
> > procs --------memory------- ---swap-- -----io---- -system-- ----cpu----
> > r b swpd free buff cache si so bi bo in cs us sy id wa
> > 3 1 230204 4972 1352 110128 2 1 17 63 24 56 12 2 85 0
> > #
>
> Does that machine really have only 256MB of RAM? And it's over 200MB into
> swap?
Huh, if that's the case then you should drop maintenance_work_mem a lot
(and not increase work_mem too much either), because having it high
enough that it causes swapping leads to worse performance.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joao Ferreira | 2008-10-30 20:19:37 | Re: speed up restore from dump |
| Previous Message | Tom Lane | 2008-10-30 20:13:29 | Re: array_cat null reasoning |