From: | Dave Crooke <dcrooke(at)gmail(dot)com> |
---|---|
To: | Pierre C <lists(at)peufeu(dot)com> |
Cc: | Merlin Moncure <mmoncure(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org, Corin <wakathane(at)gmail(dot)com>, Andy Colson <andy(at)squeakycode(dot)net> |
Subject: | Re: mysql to postgresql, performance questions |
Date: | 2010-03-22 15:32:01 |
Message-ID: | ca24673e1003220832j51f3592fn586230b5873a991b@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Absolutely ...
- for fixed size rows with a lot of small updates, Oracle wins. BTW, as of
Oracle 9 they're called "UNDO tablesapces"
- for lots of transactions and feely mixing transactions of all sizes, MVCC
tables (Postgres) wins
- if you just want a structured filesystem and don't have integrity
requirements or a lot of updates, MyISAM wins
For our app, Oracle would be the best, but it isn't strictly necessary so
Postgres wins on price ;-)
Cheers
Dave
On Mon, Mar 22, 2010 at 6:15 AM, Pierre C <lists(at)peufeu(dot)com> wrote:
> On Mon, 22 Mar 2010 12:14:51 +0100, Merlin Moncure <mmoncure(at)gmail(dot)com>
> wrote:
>
> 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 ;)
>
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Carey | 2010-03-22 18:47:43 | Re: Block at a time ... |
Previous Message | Matthew Wakeling | 2010-03-22 14:23:50 | Re: GiST index performance |