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