Postgres Pro
Downloads
Home   >   mailing lists

Re: 7.4 is great! - Mailing list pgsql-general

From jake@omnimode.com (jake johnson)
Subject Re: 7.4 is great!
Date
Msg-id 8897a0de.0311101819.124b4514@posting.google.com
Whole thread Raw
In response to 7.4 is great!  ("Oliver Siegmar" <oliver.siegmar@xams.org>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Ian Harding
Date:
Subject: Re: SQL-question: returning the id of an insert querry
Next
From: spam@fisher.forestry.uga.edu (Chris Fonnesbeck)
Date:
Subject: psql version mismatch