[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-general
Subject: Re: [HACKERS] EXPLAIN doesn't show sufficient info for wCTE cases
From: Tom Lane <tgl () sss ! pgh ! pa ! us>
Date: 2011-02-28 19:54:28
Message-ID: 28752.1298922868 () sss ! pgh ! pa ! us
[Download RAW message or body]
David Fetter <david@fetter.org> writes:
> On Mon, Feb 28, 2011 at 11:44:06AM -0500, Robert Haas wrote:
>> I think it's good to include the table name, for sure. I *think* I
>> agree that it isn't necessary to include the child names.
> Would this affect the use case of breaking up a too-long table into
> partitions?
> WITH f AS (
> DELETE FROM ONLY foo
> WHERE foo_ts >= '2011-01-01' AND foo_ts < '2011-02-01'
> RETURNING *
> )
> INSERT INTO foo_201101
> SELECT * FROM f;
In that example, each ModifyTable node is constrained to a single
target table, so I'm not sure what your point is.
regards, tom lane
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic