On Thu, Aug 6, 2009 at 12:42 PM, Campbell, Lance<la...@illinois.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.

-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

Reply via email to