Gerhard Hofmann wrote:
Hi all,
it seems that Ingres 2006 is very slow when reloading a database.
Example: a database is unloaded, unload takes about 5 minutes and
consumes about 1.6 GigaBytes of disk space -> quite good unload
performance. The same database will take over an hour (!) to reload on
the same PC.
Is this a known issue? Any workaround for this?
I have seen this problem on three PCs now (two were Win XP Pro, one was
Win 2003 Server). I definitely haven't experienced this with 2.5 / 2.6 /
3.0.3.
Hi,
I'd like to "restart" this old thread. Some of you supposed that the
different reload times between 3.0.3 were caused by different hardware,
different disk layout, weird CBF settings and so on.
Now I did some further tests, all of them on the *same* machine.
Test 1: installed Ingres 3.0.3 on Win-XP-Pro, enabled 4K DMF cache
(because all original tables were page_size=4096), left all other CBF
defaults untouched: database was reloaded in about 10 minutes.
Then upgraded this installation to Ingres 2006, destroyed + created +
reloaded database again: it took about 70 minutes!!!
Test 2: wiped out the same machine and installed to parallel instances
of Win-XP-Pro with boot mananger. Installed Ingres 3.0.3 into one
Windows instance and Ingres 2006 into the other one. For both Ingres
installations I enabled 4K DMF cache.
Reload times the same as in test 1: 10 minutes vs. 70 minutes
Test 3: disabled 4K DMF cache in Ingres 2006 installations (to have
*every* CBF setting like the default).
Tweaked the copy.in script to use page_size=2048 for every table: it
took about 70 minutes again to build the database. Same behaviour for
page_size=8192.
As my setup is out-of-the-box now, I really think this is a bug (or at
least bad design) in 2006.
Any ideas?
Regards
Gerhard
_______________________________________________
Users mailing list
Users@lists.ingres.com
http://lists.ingres.com/mailman/listinfo/users
