Received: from maia.hub.org (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id D6C046325A1
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Mon, 22 Mar 2010 08:20:56 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia,
	port 10024) with ESMTP id 55908-06
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Mon, 22 Mar 2010 11:20:39 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from 30.mail-out.ovh.net (30.mail-out.ovh.net [213.186.62.213])
	by mail.postgresql.org (Postfix) with SMTP id DDEE86324E2
	for <pgsql-performance@postgresql.org>;
	Mon, 22 Mar 2010 08:20:45 -0300 (ADT)
Received: (qmail 32584 invoked by uid 503); 22 Mar 2010 11:29:06 -0000
Received: from b9.ovh.net (HELO mail419.ha.ovh.net) (213.186.33.59)
	by 30.mail-out.ovh.net with SMTP; 22 Mar 2010 11:29:06 -0000
Received: from b0.ovh.net (HELO queueout) (213.186.33.50)
	by b0.ovh.net with SMTP; 22 Mar 2010 11:20:42 -0000
Received: from par69-8-88-161-102-87.fbx.proxad.net (HELO localhost)
	(lists%peufeu.com@88.161.102.87)
	by ns0.ovh.net with SMTP; 22 Mar 2010 11:20:42 -0000
Content-Type: text/plain; charset=utf-8; format=flowed; delsp=yes
To: "Merlin Moncure" <mmoncure@gmail.com>, "Dave Crooke" <dcrooke@gmail.com>
Cc: pgsql-performance@postgresql.org, Corin <wakathane@gmail.com>, "Andy
	Colson" <andy@squeakycode.net>
Subject: Re: mysql to postgresql, performance questions
References: <4BA23936.2030507@gmail.com> <4BA596D2.4050406@squeakycode.net>
	<b42b73151003211543w764cfb9bwe3666671310b875a@mail.gmail.com>
	<ca24673e1003211813jb05529ex33e02bcc304fbab0@mail.gmail.com>
	<ca24673e1003211814q68616580h71b4987ef8a7bae2@mail.gmail.com>
	<b42b73151003220414x44e1d143x38f765a0bdab96f@mail.gmail.com>
Date: Mon, 22 Mar 2010 12:15:51 +0100
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
From: "Pierre C" <lists@peufeu.com>
Message-ID: <op.u9yuwpqveorkce@localhost>
In-Reply-To: <b42b73151003220414x44e1d143x38f765a0bdab96f@mail.gmail.com>
User-Agent: Opera Mail/10.10 (Linux)
X-Ovh-Tracer-Id: 5947566259389400670
X-Ovh-Remote: 88.161.102.87 (par69-8-88-161-102-87.fbx.proxad.net)
X-Ovh-Local: 213.186.33.20 (ns0.ovh.net)
X-Spam-Check: DONE|U 0.5/N
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.674 tagged_above=-10 required=5 tests=AWL=-0.564,
	BAYES_05=-1.11
X-Spam-Level: 
X-Archive-Number: 201003/268
X-Sequence-Number: 38093

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 ;)