From: Guillaume Lelarge <guillaume@lelarge.info>
To: Tino Schwarze <postgresql@tisc.de>
Cc: pgsql-admin@postgresql.org
Subject: Re: Tuning postgres for fast restore?
Date: Sat, 21 Feb 2009 08:14:47 +0100
Message-ID: <499FA9E7.1040109@lelarge.info> (raw)
In-Reply-To: <20090221004219.GA10127@easy2.in-chemnitz.de>
References: <20090221004219.GA10127@easy2.in-chemnitz.de>
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.
> I currently have:
> shared_buffers = 240MB
> work_mem = 4096 # no units here, d'oh!
> maintenance_work_mem = 150000
When there's no unit, work_mem and maintenance_work_mem are in KB. You
didn't tell us your PostgreSQL release, but shared_buffers can be set at
least to 1GB and maintenance_work_mem to 512MB. You can also raise
checkpoint_segments.
Regards.
--
Guillaume.
http://www.postgresqlfr.orghttp://dalibo.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: guillaume@lelarge.info, postgresql@tisc.de
Subject: Re: Tuning postgres for fast restore?
In-Reply-To: <499FA9E7.1040109@lelarge.info>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox