Re: Best settings to load a fresh database

From: Euler Taveira de Oliveira <euler(at)timbira(dot)com>
To: Kenneth Marshall <ktm(at)rice(dot)edu>
Cc: "Campbell, Lance" <lance(at)illinois(dot)edu>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Best settings to load a fresh database
Date: 2009-08-07 07:30:34
Message-ID: 4A7BD81A.3040706@timbira.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Kenneth Marshall escreveu:
> 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.
>
And make sure archive mode is turned off. Otherwise, you can't use the WAL
bypass facility.

--
Euler Taveira de Oliveira
http://www.timbira.com/

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Kees van Dieren 2009-08-07 08:00:28 Re: SQL select query becomes slow when using limit (with no offset)
Previous Message Robert Haas 2009-08-06 19:33:02 Re: postgresql and syslog