Best settings to load a fresh database

From: "Campbell, Lance" <lance(at)illinois(dot)edu>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: Best settings to load a fresh database
Date: 2009-08-06 18:42:06
Message-ID: B10E6810AC2A2F4EA7550D072CDE876001D20F2F@SAB-FENWICK.sab.uiuc.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Kenneth Marshall 2009-08-06 19:02:03 Re: Best settings to load a fresh database
Previous Message Joshua D. Drake 2009-08-06 16:52:39 Re: Bottleneck?