On Mon, 22 Mar 2010 12:14:51 +0100, Merlin Moncure <mmoncure(at)gmail(dot)com>
> On Sun, Mar 21, 2010 at 9:14 PM, Dave Crooke <dcrooke(at)gmail(dot)com> wrote:
>> Note however that Oracle offeres full transactionality and does in
>> place row
>> updates. There is more than one way to do it.
> There's no free lunch.
MVCC : VACUUM
Oracle : Rollback Segments
MyISAM : no concurrency/transactions
It's all about which compromise suits you ;)
In response to
pgsql-performance by date
|Next:||From: Matthew Wakeling||Date: 2010-03-22 11:48:44|
|Subject: Re: too complex query plan for not exists query and
|Previous:||From: Merlin Moncure||Date: 2010-03-22 11:14:51|
|Subject: Re: mysql to postgresql, performance questions|