Re: Comparative performance - Mailing list pgsql-performance

From Magnus Hagander
Subject Re: Comparative performance
Date
Msg-id 6BCB9D8A16AC4241919521715F4D8BCE92E6D6@algol.sollentuna.se
Whole thread Raw
In response to Comparative performance  (Joe <svn@freedomcircle.net>)
Responses Re: Comparative performance  (Joe <svn@freedomcircle.net>)
List pgsql-performance
> > It appears that PostgreSQL is two to three times slower
> than MySQL.
> > For example, some pages that have some 30,000 characters
> (when saved
> > as HTML) take 1 to 1 1/2 seconds with MySQL but 3 to 4 seconds with
> > PostgreSQL.  I had read that the former was generally
> faster than the
> > latter, particularly for simple web applications but I was
> hoping that
> > Postgres' performance would not be that noticeably slower.
>
> Are you comparing PostgreSQL on XP to MySQL on XP or
> PostgreSQL on Linux to MySQL on Linux? Our performance on XP
> is not great. Also, which version of PostgreSQL are you using?

That actually depends a lot on *how* you use it. I've seen pg-on-windows
deployments that come within a few percent of the linux performance.
I've also seen those that are absolutely horrible compared.

One sure way to kill the performance is to do a lot of small
connections. Using persistent connection is even more important on
Windows than it is on Unix. It could easily explain a difference like
this.

//Magnus

pgsql-performance by date:

Previous
From: Ron Peacetree
Date:
Subject: Re: [HACKERS] A Better External Sort?
Next
From: Ron Peacetree
Date:
Subject: Re: Sequential I/O Cost (was Re: A Better External Sort?)