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/ -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
