Re: PG optimization question

From: Pierre Frédéric Caillaud <lists(at)peufeu(dot)com>
To: "Hannu Krosing" <hannu(at)2ndquadrant(dot)com>, Nickolay <nitro(at)zhukcity(dot)ru>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: PG optimization question
Date: 2010-01-10 10:52:01
Message-ID: op.u6bcgzsucke6l8@soyouz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


> 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 ...

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Mathieu De Zutter 2010-01-10 12:28:11 Choice of bitmap scan over index scan
Previous Message Craig Ringer 2010-01-10 01:24:26 Re: PG optimization question