From: Tino Schwarze <postgresql@tisc.de>
To: pgsql-admin@postgresql.org
Subject: Tuning postgres for fast restore?
Date: Sat, 21 Feb 2009 01:42:19 +0100
Message-ID: <20090221004219.GA10127@easy2.in-chemnitz.de> (raw)
Hi there,
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?
I currently have:
shared_buffers = 240MB
work_mem = 4096 # no units here, d'oh!
maintenance_work_mem = 150000
Thanks!
Tino.
--
"What we nourish flourishes." - "Was wir nähren erblüht."
www.lichtkreis-chemnitz.de
www.craniosacralzentrum.de
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: postgresql@tisc.de
Subject: Re: Tuning postgres for fast restore?
In-Reply-To: <20090221004219.GA10127@easy2.in-chemnitz.de>
* 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