>>>>> "TL" == Tom Lane <[EMAIL PROTECTED]> writes:
TL> Wes <[EMAIL PROTECTED]> writes: >> There's more than 250 million rows. If I remember right, it's ballpark 25% >> data reload, 75% index/foreign constraint rebuild. Pg_dumpall is something >> like 3 hours or so. TL> FWIW, increasing sort_mem for the reload process would probably help TL> with the index and FK rebuilds. (8.0 rejiggers things so that the I shaved significant time from 7.4.x restores by bumping up the checkpoint_segments to 50. My dumps currently take about 1.5 hours over a 100Mbit ethernet (server is on gig ethernet, dumping client is on 100Mbit). -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D. Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-301-869-4449 x806 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
