Andy Colson <andy@xxxxxxxxxxxxxxx> wrote: > On 03/17/2011 09:25 AM, Michael Andreasen wrote: >> I've been looking around for information on doing a pg_restore as >> fast as possible. >> I am using a twin processor box with 2GB of memory >> shared_buffers = 496MB Probably about right. >> maintenance_work_mem = 160MB You might get a benefit from a bit more there; hard to say what's best with so little RAM. >> checkpoint_segments = 30 This one is hard to call without testing. Oddly, some machines do better with the default of 3. Nobody knows why. >> autovacuum = false >> full_page_writes=false Good. > fsync = off > synchronous_commit = off Absolutely. > bgwriter_lru_maxpages = 0 I hadn't thought much about that last one -- do you have benchmarks to confirm that it helped with a bulk load? You might want to set max_connections to something lower to free up more RAM for caching, especially considering that you have so little RAM. -Kevin -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
