On Sat, Feb 21, 2009 at 12:14 AM, Guillaume Lelarge <guilla...@lelarge.info> wrote: > Tino Schwarze a écrit : >> [...] >> I'm going to pg_restore a database dump of about 220 GiB (uncompressed, >> but most data is BLOBs). The machine has 8 GiB of memory and 8 cores. >> Is there any advice to speed up restoring, postgresql.conf-wise? >> >> I already have a script which does the data loading and index creation >> in parallel. I'm looking for advice regarding shared_mem, work_mem and >> maintenance_mem - shall I raise them? >> > > You should definitely raise shared_buffers and maintenance_work_mem.
Also, you can disable fsync during a restore if the machine's not handling any other databases. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
