[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: Postgres 7
Thanks Dan.
I actually began investigating Postgres heavily about two weeks ago...
just to see what has come about since my last major investigation. While
there are still a few issues, I'm anxious to do some performance
benchmarks on 7.x. I've been reading good things about the 7.0 betas.
For PHP3, Postgres will still fall behind MySQL pretty dramaticly in
speed, at no fault of Postgres - it has to do with the fact that PHP3
itself has native ties ONLY with MySQL, while all other DB's go through an
"other DB" translation layer. This is fixed in PHP4 thankfully.
But, for US (as in the LKB) that doesn't matter anyway. I'm intersted in
benchmarking/testing PostgreSQL as a possible platform when we begin our
CORBA development... which will elliminate PHP from communicating with the
DB anyway.
What I'm thinking is - we begin our CORBA development with MySQL, just as
we have now. We use Python's inherit DB abstraction so that a
MySQL/Postgres swap would be painless... get to a point where we have VERY
minimal functionality in the objects (just enough for test) and then test
the hell out of both DB's to see how the speed compares with the EXACT
queries we're using both natively, and through Pythons abstraction layer.
Also, when we set Postgres up to test, I want to make sure we take
advantage of all the benefits it has over MySQL... so I expect to do
whatever tweaks neccisary to the DB to get it to perform it's best under
Postgres.
I'm hoping that 7.x's performance will make it attractive to elliminate or
nearly elliminate MySQL. But, I won't be for that course of action if it
means a major slow-down in the DB, otherwise we'll be trading in
performance on the DB, and gaining performance in the code...
I for one don't care if Postgres is a LITTLE slower than MySQL - as I'm
definately a fan of it's more robust features.... I just don't want to
compromise a 40% speed loss or anything near it.
It'll be interesting... so, we'll see.
On Tue, Apr 11, 2000 at 10:54:36AM -0400, Daniel E. Markle wrote:
> I thought you might find this information informative.
>
> PGSQL 7.0
> Tim Triche, Jr. - April 11th 2000, 03:32 EST
> The big change is the addition of foreign keys and the increase in
> performance vs. the 6.x series. Around 6.5 the database server
> stopped leaking memory and trudging through queries hideously
> slowly. In the 7.x series it is poised to achieve feature parity with
> Oracle as far as SQL DDL and DML is concerned; the multiversion
> concurrency model from Oracle was adapted for use in Postgresql's
> internals around 6.5 as well, with decidedly positive results. 7.1 is
> slated to have outer joins, at which point it might be reasonable to
> start porting lower-traffic or smaller sites from Oracle to Postgresql
> in some cases. Certainly it will make life easier for developers who
> do not want to grapple with Oracle or MySQL's shortcomings simply
> to use a good SQL92 back-end.
>
> PGSQL is a high quality opensource RDBMS which is quickly
> closing in on MySQL's application support, and blows that RDBMS
> out of the water as far as robustness is concerned. I was slated to
> replace a MySQL backend with Oracle on Linux this evening --
> while MySQL is very fast, it has not proven to be robust enough for
> an active multimedia website's framework. We don't use Postgresql
> in-house at my day job, but I have consulted with other companies
> that were very pleased with it for their backend. In any event, the
> swap-out was rescheduled for tomorrow night, so I am tweaking
> Postgresql 7.0beta5 for my own website instead.
>
> Postgresql is really the only opensource database with an active
> enough developer base and a rich enough set of features to touch
> high-end commercial RDBMS offerings. The big changes for the 7.x
> series of releases are almost all related to narrowing the remaining
> gap, and offering a Free alternative to Oracle and its ilk (Sybase,
> DB2, Informix).
>
> --
> -------------------
> Daniel E. Markle
> syntax@ashtech.net
> http://www.ashtech.net/syntax
> -------------------
--
Jason Pincin
Linux Knowledge Base Project Leader (http://www.linuxkb.org/)
http://vodka.linuxkb.org/~chardros/