Andy Colson <a...@squeakycode.net> 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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

Reply via email to