On 18 Apr 2001 12:00:57 +0530, Differentiated Software Solutions Pvt. Ltd., wrote:
> Hi,
>
> There are 4 responses to our results. We will answer them to the best of our ability.
>
> MATT >This is a very very old version of postgresql. Try it again with 7.1 for
> MATT >more respectable results.
>
> Accepted. We knew this when we conducted the benchmarks.
> We've had terrible experience with postgres. Firstly on performance and more
>importantly on availablity.
> Some of you should try pounding postgres with upwards of 25 queries a second and see
>the results. The postgres server will spew out error messages and shutdown. Last year
>we had a several nightouts writing code to protect postgres from an overload of
>queries.
> I've written several mails to postgres mailing lists and even to mod_perl in
>desperation. Problem wasn't solved.
I'm on several postgresql mailing lists and couldn't find a recent post
from you complaining about 6.5.3 performance problems (not even by an
archive search). Your benchmark is worthless until you try postgresql
7.1. There have been two major releases of postgresql since 6.5.x (ie.
7.0 and 7.1) and several minor ones over a total of 2-3 years. It's no
secret that they have tremendous performance improvements over 6.5.x. So
why did you benchmark 6.5.x?
> We'll try out 7.1. Maybe it is a major improvement over 6.5.3. I find it difficult
>to believe that it will improve performance by 36 times !!!!
I believe postgresql 7.0 had an extensive redesign in comparison to
6.5.x. So yes, you *can* expect that level of performance improvement.
> CLAYTON > i wanted a good benchmark for postgres and mysql
This is a good comparison of MySQL and PostgreSQL 7.0:
"Open Source Databases: As The Tables Turn" --
http://www.phpbuilder.com/columns/tim20001112.php3
> We haven't tried this one. We are doing a project on mysql. Our preliminary
>assessment is, it's a shocker. They justify not having commit and rollback!! Makes us
>think whether they are even lower end than MS-Access.
Again, checkout PostgreSQL 7.1 -- I believe "commit" and "rollback" (as
you put it) are available. BTW, I would like to see that comment about
MS-Access posted to pgsql-general... I dare ya. :P
Matthew
