Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id B17FC6338A8
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Mon, 22 Mar 2010 08:15:03 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia,
	port 10024) with ESMTP id 51225-10
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Mon, 22 Mar 2010 11:14:52 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-vw0-f46.google.com (mail-vw0-f46.google.com
	[209.85.212.46])
	by mail.postgresql.org (Postfix) with ESMTP id 4B47C633800
	for <pgsql-performance@postgresql.org>;
	Mon, 22 Mar 2010 08:14:53 -0300 (ADT)
Received: by vws6 with SMTP id 6so327456vws.19
	for <pgsql-performance@postgresql.org>;
	Mon, 22 Mar 2010 04:14:51 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:in-reply-to:references
	:date:message-id:subject:from:to:cc:content-type;
	bh=TqUD6BgXbK3uTL4buAvFdyzPlP43oU0raWwJkFwiquE=;
	b=vtvWXnt0V7cr5BTH46FtWiKWV8xzX9INylpHVsvJXCFbDpMPqK0nh78nuA0svpfOEn
	OS9ZjJJ9fjJzVfl5MF8tro48UOx2Bs+97q14Roi53FvdbAsqBgkSL3MbgoWkDmlT9pkn
	9x4Ai5BtLzHmka7rDm642LiVM+HklZ6B42dQM=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type;
	b=JTpuI+9mm2bHkH+xqzDwAsiU58tr4z0eGaXF7lj7cGxjU+v8O19GuiEdVfpPqkVxnp
	teCwrt6gfwCDfFlmpfTR5VD5L7Wy7Ph/87pgI1Q8cqmxp7xAlQZJkL3Wf36Ry2dijE6M
	VR7vTNq1HcTjkh2rx69bbvm+4xskg7433L33w=
MIME-Version: 1.0
Received: by 10.220.124.71 with SMTP id t7mr1815140vcr.70.1269256491581; Mon,
	22 Mar 2010 04:14:51 -0700 (PDT)
In-Reply-To: <ca24673e1003211814q68616580h71b4987ef8a7bae2@mail.gmail.com>
References: <4BA23936.2030507@gmail.com> <4BA596D2.4050406@squeakycode.net>
	<b42b73151003211543w764cfb9bwe3666671310b875a@mail.gmail.com>
	<ca24673e1003211813jb05529ex33e02bcc304fbab0@mail.gmail.com>
	<ca24673e1003211814q68616580h71b4987ef8a7bae2@mail.gmail.com>
Date: Mon, 22 Mar 2010 07:14:51 -0400
Message-ID: <b42b73151003220414x44e1d143x38f765a0bdab96f@mail.gmail.com>
Subject: Re: mysql to postgresql, performance questions
From: Merlin Moncure <mmoncure@gmail.com>
To: Dave Crooke <dcrooke@gmail.com>
Cc: pgsql-performance@postgresql.org, Corin <wakathane@gmail.com>,
	Andy Colson <andy@squeakycode.net>
Content-Type: text/plain; charset=ISO-8859-1
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5
	tests=BAYES_00=-2.599
X-Spam-Level: 
X-Archive-Number: 201003/267
X-Sequence-Number: 38092

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.  If you do mvcc you have to maintain multiple
versions of the same row.

merlin