Thread: 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