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