On Thu, Aug 6, 2009 at 12:42 PM, Campbell, Lance<lance@xxxxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
