Re: Path question - Mailing list pgsql-hackers

From Robert Haas
Subject Re: Path question
Date
Msg-id 7D02C7EC-93D2-4B09-9A0D-1655AF87179A@gmail.com
Whole thread Raw
In response to Re: Path question  (Greg Stark <gsstark@mit.edu>)
Responses Re: Path question  (Hans-Jürgen Schönig <hs@cybertec.at>)
List pgsql-hackers
On Sep 1, 2010, at 10:21 AM, Greg Stark <gsstark@mit.edu> wrote:
> For what it's worth I disagree with Tom. I think this is a situation
> where we need *both* types of solution. Ideally we will be able to use
> a plain Append node for cases where we know the relative ordering of
> the data in different partitions, but there will always be cases where
> the structured partition data doesn't actually match up with the
> ordering requested and we'll need to fall back to a merge-append node.

I agree. Explicit partitioning may open up some additional optimization possibilities in certain cases, but Merge
Appendis more general and extremely valuable in its own right. 

...Robert

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Fix for pg_upgrade's forcing pg_controldata into English
Next
From: Robert Haas
Date:
Subject: Re: "serializable" in comments and names