Re: Postgres performance comments from a MySQL user

Could you clarify are you moving from MySQL or Microsoft SQL 7.0?

-----Original Message-----
From: Avi Schwartz [mailto:avi(at)CFFtechnologies(dot)com]
Sent: Wednesday, June 11, 2003 7:21 PM
To: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Postgres performance comments from a MySQL user

We are currently in the middle of a process of moving from SQL Server 7
to PostgreSQL. We are running PostgreSQL 7.3.2 *untuned* on a 384M
single CPU machine and it beats a 4 CPU server with 2GB of memory
running SQL Server 7. This application is using stored procedures
returning result sets quite heavily and I was extremely and positively
surprised from PostgreSQL's performance.

Bottom line is that you have to try it yourself and see how it performs
in your environment and in your application.

Avi

On Wednesday, Jun 11, 2003, at 11:49 America/Chicago, Tom Lane wrote:

> "Jay O'Connor" <joconnor(at)cybermesa(dot)com> writes:
>> One comment he got from the architect of another web site is as
>> follows
>
> As best I can tell, this comment is based on ancient information.
> Postgres has gotten very substantially faster over the years ... and
> it also helps a lot to know something about how to tune it (the
> out-of-the-box settings are excessively conservative). I would not
> put a lot of stock in hearsay evaluations of performance, especially
> not from someone who hasn't tested recent PG releases.

---------------------------(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)