Re: Best settings to load a fresh database

От: Kenneth Marshall
Тема: Re: Best settings to load a fresh database
Дата: ,
Msg-id: 20090806190203.GV6960@it.is.rice.edu
(см: обсуждение, исходный текст)
Ответ на: Best settings to load a fresh database  ("Campbell, Lance")
Ответы: Re: Best settings to load a fresh database  (Euler Taveira de Oliveira)
Список: 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, )

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


В списке pgsql-performance по дате сообщения:

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