From: Pierre Frédéric Caillaud <lists@peufeu.com>
To: Robert Haas <robertmhaas@gmail.com>
Cc: Hannu Krosing <hannu@2ndquadrant.com>
Cc: Nickolay <nitro@zhukcity.ru>
Cc: pgsql-performance@postgresql.org
Subject: Re: PG optimization question
Date: Mon, 11 Jan 2010 12:25:26 +0100
Message-ID: <op.u6c8ooojcke6l8@soyouz> (raw)
In-Reply-To: <603c8f071001101045wb99b337j3e1dabe9ead97421@mail.gmail.com>
References: <4B485975.70506@zhukcity.ru>
<2f4958ff1001090418i78dee992t5ff2d78a54187c07@mail.gmail.com>
<4B4879A0.2060703@zhukcity.ru>
<20100109124646.GA8123@it.is.rice.edu>
<4B487D9C.9020507@zhukcity.ru>
<op.u59u0rgecke6l8@soyouz>
<4B48CFDF.7090406@zhukcity.ru>
<1263075977.6481.9.camel@hvost>
<op.u6bcgzsucke6l8@soyouz>
<603c8f071001101045wb99b337j3e1dabe9ead97421@mail.gmail.com>
On Sun, 10 Jan 2010 19:45:32 +0100, Robert Haas <robertmhaas@gmail.com>
wrote:
> 2010/1/10 Pierre Frédéric Caillaud <lists@peufeu.com>:
>>
>>> If you transfer (delete from staging, insert into archive) in one
>>> transaction , then it will be always visible in exactly one of them,
>>> and exatly once in a view over both staging and archive(s).
>>
>> Does the latest version implement this :
>>
>> INSERT INTO archive (...) DELETE FROM staging WHERE ... RETURNING ...
>
> No. There are no plans to support that, though there are proposals to
> support:
>
> WITH x AS (DELETE FROM staging WHERE ... RETURNING ...) INSERT INTO
> archive (...) SELECT ... FROM x
>
> I'm not sure how much that will help though since, in the designs so
> far discused, the tuples won't be pipelined.
>
> ...Robert
>
Yeah, but it's a lot more user-friendly than SELECT FOR UPDATE, INSERT
SELECT, DELETE...
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: lists@peufeu.com, robertmhaas@gmail.com, hannu@2ndquadrant.com, nitro@zhukcity.ru
Subject: Re: PG optimization question
In-Reply-To: <op.u6c8ooojcke6l8@soyouz>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox