Re: Best settings to load a fresh database

From: Kenneth Marshall <ktm(at)rice(dot)edu>
To: "Campbell, Lance" <lance(at)illinois(dot)edu>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Best settings to load a fresh database
Date: 2009-08-06 19:02:03
Message-ID: 20090806190203.GV6960@it.is.rice.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Thu, Aug 06, 2009 at 01:42:06PM -0500, Campbell, Lance wrote:
> PostgreSQL 8.3
> Linux RedHat 4.X
> 24G of memory
>
> When loading a file generated from pg_dumpall is there a key setting in
> the configuration file that would allow the load to work faster.
>
> Thanks,
>
> Lance Campbell
> Project Manager/Software Architect/DBA
> Web Services at Public Affairs
> 217-333-0382
>

I have found that increasing maintenance_work_mem speeds
index rebuilds, turn off synchronous_commit or fsync if
you really can afford to start over. Another big help is
to use the parallel pg_restore from PostgreSQL 8.4.0 to
perform the restore.

Cheers,
Ken

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Robert Haas 2009-08-06 19:33:02 Re: postgresql and syslog
Previous Message Campbell, Lance 2009-08-06 18:42:06 Best settings to load a fresh database