Re: Recommendations for partitioning?

From: Dave Johansen <davejohansen(at)gmail(dot)com>
To: Shaun Thomas <sthomas(at)optionshouse(dot)com>
Cc: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, Jeff Janes <jeff(dot)janes(at)gmail(dot)com>, pgsql-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Recommendations for partitioning?
Date: 2013-12-20 16:23:07
Message-ID: CAAcYxUec197ZbYoMms4DvUpX1yH425d=ypehppY9hzogpxwCfw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Fri, Dec 20, 2013 at 9:18 AM, Shaun Thomas <sthomas(at)optionshouse(dot)com>wrote:

> On 12/20/2013 09:59 AM, Alvaro Herrera wrote:
>
> WITH moved AS (
>> DELETE FROM src WHERE ..
>> RETURNING *
>> ) INSERT INTO dst SELECT * FROM moved;
>>
>
> I know that's effectively an atomic action, but I'd feel a lot more
> comfortable reversing that logic so the delete is based on the results of
> the insert.
>
> WITH saved AS (
> INSERT INTO dst
> SELECT * FROM src WHERE ...
> RETURNING *
> )
> DELETE FROM src
> WHERE ...;
>
> I'll admit yours is cleaner, though. :)
>

That is a good idea. I didn't even realize that there was such a command,
so I'll definitely use those.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Dave Johansen 2013-12-20 16:24:40 Re: Recommendations for partitioning?
Previous Message Shaun Thomas 2013-12-20 16:18:21 Re: Recommendations for partitioning?