pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Robert Haas <robertmhaas@gmail.com>
To: Pierre Frédéric Caillaud <lists@peufeu.com>
Cc: Hannu Krosing <hannu@2ndquadrant.com>
Cc: Nickolay <nitro@zhukcity.ru>
Cc: pgsql-performance@postgresql.org
Subject: Re: PG optimization question
Date: Sun, 10 Jan 2010 13:45:32 -0500
Message-ID: <603c8f071001101045wb99b337j3e1dabe9ead97421@mail.gmail.com> (raw)
In-Reply-To: <op.u6bcgzsucke6l8@soyouz>
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>

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



view thread (14+ messages)  latest in thread

Message-ID: <603c8f071001101045wb99b337j3e1dabe9ead97421@mail.gmail.com>
Permalink:  ../603c8f071001101045wb99b337j3e1dabe9ead97421@mail.gmail.com/
Also on:    postgresql.org/message-id/603c8f071001101045wb99b337j3e1dabe9ead97421@mail.gmail.com

 · 

reply
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: robertmhaas@gmail.com, lists@peufeu.com, hannu@2ndquadrant.com, nitro@zhukcity.ru
  Subject: Re: PG optimization question
  In-Reply-To: <603c8f071001101045wb99b337j3e1dabe9ead97421@mail.gmail.com>

* 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