Best settings to load a fresh database

От: Campbell, Lance
Тема: Best settings to load a fresh database
Дата: ,
Msg-id: B10E6810AC2A2F4EA7550D072CDE876001D20F2F@SAB-FENWICK.sab.uiuc.edu
(см: обсуждение, исходный текст)
Ответы: Re: Best settings to load a fresh database  (Scott Marlowe)
Re: Best settings to load a fresh database  (Kenneth Marshall)
Список: pgsql-performance

Скрыть дерево обсуждения

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 по дате сообщения:

От: "Joshua D. Drake"
Дата:
Сообщение: Re: Bottleneck?
От: Euler Taveira de Oliveira
Дата:
Сообщение: Re: Best settings to load a fresh database