Best settings to load a fresh database

From: Campbell, Lance
Subject: Best settings to load a fresh database
Date: ,
Msg-id: B10E6810AC2A2F4EA7550D072CDE876001D20F2F@SAB-FENWICK.sab.uiuc.edu
(view: Whole thread, Raw)
Responses: Re: Best settings to load a fresh database  (Scott Marlowe)
Re: Best settings to load a fresh database  (Kenneth Marshall)
List: pgsql-performance

Tree view

Best settings to load a fresh database  ("Campbell, Lance", )
 Re: Best settings to load a fresh database  (Scott Marlowe, )
 Re: Best settings to load a fresh database  (Kenneth Marshall, )
  Re: Best settings to load a fresh database  (Euler Taveira de Oliveira, )

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


pgsql-performance by date:

From: "Joshua D. Drake"
Date:
Subject: Re: Bottleneck?
From: Euler Taveira de Oliveira
Date:
Subject: Re: Best settings to load a fresh database