Re: Ways to speed up dump&reload

max out your checkpoint_segments. 128 or 256 is good if you have
plenty of spare space for the pg_xlog directory. you will also want
to increase checkpoint_timeout to something large. I like 900 seconds
personally. if you can put pg_xlog on a separate physical RAID you're
best off.

increase the amount of ram your index operations can use (sort_mem or
work_mem depending on PG version) to a very large number and then
reset that to a normal value when you're done.

then just let pg_dump + pg_restore do its work.

--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D. Khera Communications, Inc.
Internet: khera(at)kciLink(dot)com Rockville, MD +1-301-869-4449 x806
AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/