Re: dump_all/restore times?

>>>>> "n" == nolan <nolan(at)celery(dot)tssi(dot)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(at)kciLink(dot)com Rockville, MD +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/