Re: how many record versions - Mailing list pgsql-general

From Tom Lane
Subject Re: how many record versions
Date
Msg-id 27827.1085345258@sss.pgh.pa.us
Whole thread Raw
In response to Re: how many record versions  (Manfred Koizar <mkoi-pg@aon.at>)
List pgsql-general
Manfred Koizar <mkoi-pg@aon.at> writes:
> On Sun, 23 May 2004 23:32:48 +0700, David Garamond
> <lists@zara.6.isreserved.com> wrote:
>> I'm contemplating of moving to Postgres, but am worried with the MVCC
>> thing. I've previously tried briefly using InnoDB in MySQL but have to
>> revert back to MyISAM because the load increased significantly.

> You mean InnoDB cannot handle the load?

I suspect what he meant is that InnoDB had exactly the same performance
issues with lots-of-dead-rows that Postgres will have.  Around here,
however, we are accustomed to that behavior and know how to deal with
it, whereas I'll bet the MySQL community hasn't got that down yet ...

            regards, tom lane

pgsql-general by date:

Previous
From: Philip
Date:
Subject: pg_dump error
Next
From: Greg Stark
Date:
Subject: Re: how many record versions