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