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!