From: | Jeremy Kister <pgsql-general-01(at)jeremykister(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | fastest way to upgrade from 8.2 to 8.3 |
Date: | 2009-01-15 18:02:58 |
Message-ID: | 496F7A52.80800@jeremykister.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I've got two 300GB databases that I'm going to be upgrading from 8.2.4 (32
bit) to 8.3.5 (64 bit).
The systems are running on Solaris 10u5 64bit with lots of disks in a zfs
raid10 and have 32GB ram.
I've read lots of docs and Google, and found a special flavor of
postgresql.conf that helps the import speed along, but the dump + import
process still takes about 15 hours.
here are the parameters that i've found help in postgresql.conf during an
import:
max_connections = 10
shared_buffers = 32MB
work_mem = 2048MB
maintenance_work_mem = 2048MB
max_fsm_pages = 1024000
fsync = off
wal_buffers = 1MB
commit_delay = 10000
checkpoint_segments = 128
effective_cache_size = 10GB
autovacuum = off
Can anyone give me tips to get from 8.2 to 8.3 faster ?
--
Jeremy Kister
http://jeremy.kister.net./
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Wenk | 2009-01-15 18:17:56 | Re: MD5 password issue |
Previous Message | Kirk Strauser | 2009-01-15 17:41:51 | Re: Why would I want to use connection pooling middleware? |