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! ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings