7.4 is great!
Hi all,
just wanted to let you know (maybe you also know :)) - pgsql 7.4 is great!
I had do migrate a mysql database to pgsql within the database -
dump mysql database
restore that dump in pgsql
spread about 30 tables in >160 new tables (new database design)
...this migration took about 3,5 hrs. with 7.3 (on a XEON 2,4 with two gig
of RAM). With 7.4RC1 the same migration took 67 minutes (yes the migration
is complete :)! I'm really amazed!
Thanks a bunch for that release to the developers.
Bye,
Oliver
PS: For PgSQL 7.5 - please improve the inheritance model :-)
PRIVATE KEY inheritance would be really helpful!
oliver.siegmar@xams.org ("Oliver Siegmar") wrote in message news:<47338.194.97.5.114.1068055682.squirrel@siegmar.sitix.net>...
Hi all,
just wanted to let you know (maybe you also know :)) - pgsql 7.4 is great!
I had do migrate a mysql database to pgsql within the database -
[...snip...]
Yes and that's not even commenting on the performance jump. I must
say I'm seeing up to a 200% improvement on some queries I've been
testing in comparison to v7.34. This is on i386-unknown-freebsd4.7,
compiled by GCC 2.95.4
Even on those SELECT count(*) queries, I see over 100% improvement.
This is before any real effort at tuning.
Thank you PG developers!!
- Jake