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

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

2016-12-21 Thread Ashutosh Bapat
Hi, 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, any inheritance hierarchy is flattened out including partit