Re: [pgadmin-hackers] Declarative partitioning in pgAdmin4 - Mailing list pgadmin-hackers

From Akshay Joshi
Subject Re: [pgadmin-hackers] Declarative partitioning in pgAdmin4
Date
Msg-id CANxoLDcDDKObTdO69KfM40Y09KL6T93uR5RymvjDybZPjpAw2A@mail.gmail.com
Whole thread Raw
In response to Re: [pgadmin-hackers] Declarative partitioning in pgAdmin4  (Shirley Wang <swang@pivotal.io>)
List pgadmin-hackers
Hi Shirley

On Tue, May 23, 2017 at 7:39 PM, Shirley Wang <swang@pivotal.io> wrote:
It's less about implementing what's easy, and more about implementing what we know for sure will provide user value. 

   Agreed, but if that feature(expression) is available in postgresql then users/QA will ask why that is not present in pgAdmin4. If implementation is complex then we could think to include it or not, if we will provide that its upto the user they want to use it or not.

Given that in the expression you used, the variables 'a' and 'b' have undefined values, there's still a chance that we're missing a large chunk of context for successful implementation. 

Could you explain what 'a' and 'b' represent? 
Where would users find values for 'a' and 'b'? (are they columns?)

    a and b are columns. 
What is the use case for partitioning by (a+b)/2? 
How frequently will people partition this way?

    That is just an example of expression, there is no use case for above example.   

It's possible to design for the range and list partitions and know we can achieve success because we understand how users would go through this workflow. Not sure about expressions.






--
Akshay Joshi
Principal Software Engineer 


Phone: +91 20-3058-9517
Mobile: +91 976-788-8246

pgadmin-hackers by date:

Previous
From: Shruti B Iyer
Date:
Subject: Re: [pgadmin-hackers] [pgAdmin4][PATCH] Improvements to Query ResultsGrid User Experience
Next
From: Akshay Joshi
Date:
Subject: Re: [pgadmin-hackers] Declarative partitioning in pgAdmin4