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 -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
