Re: PG optimization question - Mailing list pgsql-performance

From Pierre Frédéric Caillaud
Subject Re: PG optimization question
Date
Msg-id op.u6bcgzsucke6l8@soyouz
Whole thread Raw
In response to PG optimization question  (Nickolay <nitro@zhukcity.ru>)
Responses Re: PG optimization question
List 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 ...


pgsql-performance by date:

Previous
From: Craig Ringer
Date:
Subject: Re: PG optimization question
Next
From: Mathieu De Zutter
Date:
Subject: Choice of bitmap scan over index scan