Re: Proposal: Partitioning Advisor for PostgreSQL

2018-06-12 Thread Julien Rouhaud
Hi, On Tue, Jun 12, 2018 at 11:14 AM, Dilip Kumar wrote: > On Thu, May 24, 2018 at 4:16 PM, Yuzuko Hosoya > wrote: >> >> This is >> why we are working on partitioning advisor. We plan to release the first >> version >> of partitioning advisor for PostgreSQL 11, and then, improve it for >> Postg

Re: Proposal: Partitioning Advisor for PostgreSQL

2018-06-12 Thread Dilip Kumar
On Thu, May 24, 2018 at 4:16 PM, Yuzuko Hosoya wrote: > Hello, > > I'm Yuzuko Hosoya. This is my first PostgreSQL project participation. > > I have been developing partitioning advisor prototype with Julien Rouhaud. > It will be a new feature of HypoPG[1], which is a PostgreSQL extension, and > w

Re: Proposal: Partitioning Advisor for PostgreSQL

2018-06-12 Thread Ashutosh Bapat
On Tue, Jun 12, 2018 at 12:21 AM, Julien Rouhaud wrote: > > I both like and dislike this idea. The good thing is that it's way > less hacky than what we did in our prototype, and it's also working > out of the box. However, the problem I have with this approach is > that the generated plans will

Re: Proposal: Partitioning Advisor for PostgreSQL

2018-06-11 Thread Julien Rouhaud
Hi Ashutosh, Thanks for answering! And I'm very sorry for the time I needed to reply On Wed, May 30, 2018 at 5:44 PM, Ashutosh Bapat wrote: > On Thu, May 24, 2018 at 4:16 PM, Yuzuko Hosoya >> >> However, PostgreSQL isn't designed to have hypothetical tables, > > I agree. But there are light-wei

Re: Proposal: Partitioning Advisor for PostgreSQL

2018-05-30 Thread Ashutosh Bapat
On Thu, May 24, 2018 at 4:16 PM, Yuzuko Hosoya wrote: > Hello, > > I'm Yuzuko Hosoya. This is my first PostgreSQL project participation. > > I have been developing partitioning advisor prototype with Julien Rouhaud. > It will be a new feature of HypoPG[1], which is a PostgreSQL extension, and > wi

Proposal: Partitioning Advisor for PostgreSQL

2018-05-24 Thread Yuzuko Hosoya
Hello, I'm Yuzuko Hosoya. This is my first PostgreSQL project participation. I have been developing partitioning advisor prototype with Julien Rouhaud. It will be a new feature of HypoPG[1], which is a PostgreSQL extension, and will help partitioning design tuning. Currently, HypoPG only support