Search Postgresql Archives

Re: how many record versions

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux