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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
