| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Manfred Koizar <mkoi-pg(at)aon(dot)at> |
| Cc: | David Garamond <lists(at)zara(dot)6(dot)isreserved(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: how many record versions |
| Date: | 2004-05-23 20:47:38 |
| Message-ID: | 27827.1085345258@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Manfred Koizar <mkoi-pg(at)aon(dot)at> writes:
> On Sun, 23 May 2004 23:32:48 +0700, David Garamond
> <lists(at)zara(dot)6(dot)isreserved(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Stark | 2004-05-23 21:36:07 | Re: how many record versions |
| Previous Message | Philip | 2004-05-23 19:32:33 | pg_dump error |