Re: [HACKERS] multi-level partitions and partition-wise joins

2017-02-01 Thread Robert Haas
On Fri, Dec 23, 2016 at 12:54 AM, Ashutosh Bapat wrote: > Another question: do we want to commit the code for creating > unflattened hierarchy separately or along with partition-wise join? Probably separately. I suggest posting a series of two (or perhaps more) patches on the same thread. 'git

Re: [HACKERS] multi-level partitions and partition-wise joins

2016-12-22 Thread Ashutosh Bapat
Another question: do we want to commit the code for creating unflattened hierarchy separately or along with partition-wise join? On Fri, Dec 23, 2016 at 9:58 AM, Ashutosh Bapat wrote: > On Thu, Dec 22, 2016 at 10:52 PM, Robert Haas wrote: >> On Wed, Dec 21, 2016 at 11:31 PM, Ashutosh Bapat >> w

Re: [HACKERS] multi-level partitions and partition-wise joins

2016-12-22 Thread Ashutosh Bapat
On Thu, Dec 22, 2016 at 10:52 PM, Robert Haas wrote: > On Wed, Dec 21, 2016 at 11:31 PM, Ashutosh Bapat > wrote: >> Given the scenario described above, it looks like we have to retain >> partition hierarchy in the form of inheritance hierarchy in order to >> implement partition-wise joins for mul

Re: [HACKERS] multi-level partitions and partition-wise joins

2016-12-22 Thread Robert Haas
On Wed, Dec 21, 2016 at 11:31 PM, Ashutosh Bapat wrote: > Given the scenario described above, it looks like we have to retain > partition hierarchy in the form of inheritance hierarchy in order to > implement partition-wise joins for multi-leveled partition tables. Is > that the right thing to do?

Re: [HACKERS] multi-level partitions and partition-wise joins

2016-12-21 Thread Ashutosh Bapat
On Wed, Dec 21, 2016 at 10:25 PM, Robert Haas wrote: > On Wed, Dec 21, 2016 at 6:36 AM, Ashutosh Bapat > wrote: >> I am starting this as a separate thread for this since the declarative >> partitioning thread has many issues reported and it's better to keep >> this discussion separate from the is

Re: [HACKERS] multi-level partitions and partition-wise joins

2016-12-21 Thread Robert Haas
On Wed, Dec 21, 2016 at 6:36 AM, Ashutosh Bapat wrote: > I am starting this as a separate thread for this since the declarative > partitioning thread has many issues reported and it's better to keep > this discussion separate from the issues reported on that thread. > > While expanding inheritance