Re: mysql to postgresql, performance questions - Mailing list pgsql-performance

From Pierre C
Subject Re: mysql to postgresql, performance questions
Date
Msg-id op.u9yuwpqveorkce@localhost
Whole thread Raw
In response to Re: mysql to postgresql, performance questions  (Merlin Moncure <mmoncure@gmail.com>)
Responses Re: mysql to postgresql, performance questions  (Dave Crooke <dcrooke@gmail.com>)
List pgsql-performance
On Mon, 22 Mar 2010 12:14:51 +0100, Merlin Moncure <mmoncure@gmail.com>
wrote:

> On Sun, Mar 21, 2010 at 9:14 PM, Dave Crooke <dcrooke@gmail.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 ;)

pgsql-performance by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: mysql to postgresql, performance questions
Next
From: Matthew Wakeling
Date:
Subject: Re: too complex query plan for not exists query and multicolumn indexes