Postgres Pro
Downloads
Home   >   mailing lists

Re: Best settings to load a fresh database - Mailing list pgsql-performance

From Euler Taveira de Oliveira
Subject Re: Best settings to load a fresh database
Date
Msg-id 4A7BD81A.3040706@timbira.com
Whole thread Raw
In response to Re: Best settings to load a fresh database  (Kenneth Marshall <ktm@rice.edu>)
List pgsql-performance
Tree view 
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/

pgsql-performance by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Bottleneck?
Next
From: Kees van Dieren
Date:
Subject: Re: SQL select query becomes slow when using limit (with no offset)