Re: pg_restore error

From: Steve Crawford <scrawford(at)pinpointresearch(dot)com>
To: Bryan White <nicktook(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_restore error
Date: 2010-04-17 21:53:36
Message-ID: 4BCA2DE0.5090602@pinpointresearch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Bryan White wrote:
> ...
> The new server is a dual socket Nahalem. 8 cores, 16 threads, 48 GB
> ram, 2 WAL drives in RAID1 and 12 database drives in RAID10.
>
I would try setting -j higher - in your case try 8 for starters. Also
turn off fsync and autovacuum (and turn them back on !!!). See these and
more tips at:
http://it.toolbox.com/blogs/database-soup/using-84-parallel-restore-with-your-83-or-82-database-31575

Cheers,
Steve

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Bryan White 2010-04-17 22:09:24 Re: pg_restore error
Previous Message Bryan White 2010-04-17 20:08:34 Re: pg_restore error