omaha
02-04-2010, 05:54 AM
I have a huuuuuge db that was with postgres 8.3, and a solid state drive. The initial import speed was 200 hands/sec, and thelast import speed was 170 hands/seconds. This had never been analysed
For some strange reason, i decided to uninstall hem and reinstall it, it installed postgres 8.4.
Initially, i got about 70 hands/seconds, which is woeful, and what i got with a cruddy hard disk
So, i used the tuning wizard, and Now, with a brand new db, I get about 100 hands/sec import
So, now i have two questions
WHy is 8.4 much worse than 8.3?
Is it possible to uninstall what i have, and put an old version back on?
For some strange reason, i decided to uninstall hem and reinstall it, it installed postgres 8.4.
Initially, i got about 70 hands/seconds, which is woeful, and what i got with a cruddy hard disk
So, i used the tuning wizard, and Now, with a brand new db, I get about 100 hands/sec import
So, now i have two questions
WHy is 8.4 much worse than 8.3?
Is it possible to uninstall what i have, and put an old version back on?