Postgres performance comments from a MySQL user

From: "Jay O'Connor" <joconnor(at)cybermesa(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Postgres performance comments from a MySQL user
Date: 2003-06-11 16:15:50
Message-ID: 20030611091550.A1128@altaica
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Some backs-story. I'm in the process of converting our internal file based
data storage to an RDBMS. After looking a bit at PostgreSQL and MySQL, I
chose Postgresql. My boss has heard of MySQL and has not heard of
PostgreSQL and every now and then ahe make allusions that we shuold be
using MySQL.

One comment he got from the architect of another web site is as follows

> If we were to start again
> from scratch now, I'd still use InnoDB over postgres unless the
> performance picked up with postgres recently.
>
> Keep in mind our application is very write-heavy so your numbers may
> be different. Does postgres still keep the old row versions in the
> primary-key B-Tree? If it does I doubt performance improved much for
> write-heavy apps, that was a very poor design decision by them. InnoDB
> takes the Oracle route of moving old row versions to a seperate
> on-disk data structure.

Does what he say make sense? If so, has the situation changed? BNasically,
I need something intelligent to say to my boss to either counter or
mitigate his perception.

Thanks

Take care,
Jay

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-06-11 16:19:31 Re: Multilple email being delivered
Previous Message Tony Grant 2003-06-11 16:10:19 Re: RE : PostgreSQL coredump : Couldn't find any tables,