Re: [ADMIN] Tuning postgres for fast restore?

2009-02-22 Thread Scott Marlowe
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

[ADMIN] Tuning postgres for fast restore?

2009-02-20 Thread Tino Schwarze
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

Re: [ADMIN] Tuning postgres for fast restore?

2009-02-20 Thread Guillaume Lelarge
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