** Reply to message from Thierry Missimilly <THIERRY(dot)MISSIMILLY(at)BULL(dot)NET> on
Tue, 15 Apr 2003 11:41:47 +0200
Hi,
About 450 tables (+ lots of views:)
Row counts range from 0 to about 3 million.
Database sizes range from about 600 meg (a bus company with about 50 busses
and a years fueling/servicing/rostering history) to around 12 gig currently :).
We are not newbies with db2. We have been using/suppling it since version
2.1(We actually started development on ver 1. something, but didn't ship till
after the version 2 release :). We do do a good job of tuning db2.
Nevertheless, performance of postgresql across the board (and we have not
designed for postgres like we did for db2), leaves db2 for dead most places.
Regards,
Wayne
> Hi,
> Your experience is very interesting.
> But could you tell me what is the Database size ?
>
> Regards,
> Thierry
>
> Wayne Armstrong wrote:
>
> > ** Reply to message from Tony Grant <tony(at)tgds(dot)net> on 15 Apr 2003 08:12:04
> > +0200
> > Hi,
> > I've got to agree with this.
> > We have just been through the excercise of porting our quite extensive fleet
> > maintenance and accounting package from db2 to postgres. While the port was not
> > without pain :) the results are very good. We run windows clients, (mostly),
> > and whatever the database of choice performs best on for the backend. We are
> > seeing performance gains for the 20-100 user bracket of a factor of 10 to 20
> > for switching from db2 to postgres on the same platform.
> > We literally could not port this stuff to mysql. It does not have enough
> > feature to support us :)
> > Definitely the story is not that postgres competes with mysql/access but
> > rather with db2/oracle, and the point in time recovery coming in the next
> > release, just strengthens that story a whole lot more too.
> >
> > And, client reaction to an opensource (free :) database on linux has been very
> > enthusiastic.
> >
> > Regards,
> > Wayne
> > http://www.bacchus.com.au
> >
> > > On Tue, 2003-04-15 at 00:37, Bruce Momjian wrote:
> > > > Several people have asked if we are losing momentum. Specifically, they
> > > > are concerned about Red Hat dropping their Red Hat Database and instead
> > > > distributing PostgreSQL as part of Red Hat Enterprise Server, and they
> > > > are concerned about recent press articles about MySQL.
> > >
> > > Just reading GENERAL every day shows quite the contrary! There are more
> > > and more questions which really belong on NOVICE. More and more
> > > questions about porting applications from MySQL and Access.
> > >
> > > RedHat renaming "PostgreSQL" to "PostgreSQL" after a short stint a.k.a.
> > > "Red Hat Database" is a very positive step.
> > >
> > > Lots of stupid journalists are starting to write "replace Oracle with
> > > MySQL" rubbish. I am very concerned about this because the DBA who is
> > > stupid enough to do this will fail miserably and get the wrong
> > > impression about free RDBMS.
> > >
> > > Lets forget the "replace MySQL with PostgreSQL" stuff and go looking for
> > > higher end converts. Our marketing push should be "replace Oracle with
> > > PostgreSQL and replace Access with MySQL". This puts the emphasis on
> > > which database can do what...
> > >
> > > Just my 2 EURO cents
> > >
> > > Cheers
> > > Tony Grant
> > > (yes I use PostgreSQL where MySQL would suffice...)
> > >
> > > --
> > > www.tgds.net Library management software toolkit,
> > > redhat linux on Sony Vaio C1XD,
> > > Dreamweaver MX with Tomcat and PostgreSQL
> > >
> > >
> > > ---------------------------(end of broadcast)---------------------------
> > > TIP 2: you can get off all lists at once with the unregister command
> > > (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org