Re: Best settings to load a fresh database

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
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: dcc563d10908061202h772c92f5jfc1fd095a5bebfcb@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Thu, Aug 6, 2009 at 12:42 PM, Campbell, Lance<lance(at)illinois(dot)edu> 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.

The ones I can think of are cranking up work_mem and
maintenance_work_mem and disabling fsync. Be sure to renable fsync
afterwards if you value your data.

In response to

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