>>>>> "n" == nolan <nolan@celery.tssi.com> writes:
n> It didn't seem to get into the indexing part until the last 2-3 hours,
n> I think most of that time was just loading data.
n> I can run the load again, this system was set up so I could develop more
n> familiarity with FreeBSD and to have a place to run CVS, the data
n> is just there to have something to test 7.4 with.
Last dump/restore I did when moving from 7.1 to 7.2 took something
like 8 hours, but that was many GB ago ;-)
For my data, the load takes about 2-3 hours, and the rest of the time
indexing. I don't see how FK's really will affect restore since they
are not installed until after the data is fully loaded.
I'll have to keep in mind the sort_mem setting when I do this again...
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D. Khera Communications, Inc.
Internet: khera@kciLink.com Rockville, MD +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/