Re: On partitioning

Amit Langote <langote_amit_f8@lab.ntt.co.jp>

From: "Amit Langote" <Langote_Amit_f8@lab.ntt.co.jp>
To: "'Andres Freund'" <andres@2ndquadrant.com>, "'Alvaro Herrera'" <alvherre@2ndquadrant.com>
Cc: "'Bruce Momjian'" <bruce@momjian.us>, "'Pg Hackers'" <pgsql-hackers@postgresql.org>
Date: 2014-10-28T05:34:22Z
Lists: pgsql-hackers
Hi,

> From: Andres Freund [mailto:andres@2ndquadrant.com]
> On 2014-10-27 06:29:33 -0300, Alvaro Herrera wrote:
> > Amit Langote wrote:
> > > FWIW, I think Robert's criticism regarding not basing this on
inheritance
> > > scheme was not responded to.
> >
> > It was responded to by ignoring it.  I didn't see anybody else
> > supporting the idea that inheritance is in any way a sane thing to base
> > partitioning on.  Sure, we have accumulated lots of kludges over the
> > years to cope with the fact that, really, it doesn't work very well.  So
> > what.  We can keep them, I don't care.
> 
> As far as I understdood Robert's criticism it was more about the
> internals, than about the userland representation. To me it's absolutely
> clear that 'real partitioning' userland shouldn't be based on the
> current hacks to allow it. 

For my understanding: 

By partitioning 'userland' representation, do you mean an implementation
choice where a partition is literally an inheritance child of the partitioned
table as registered in pg_inherits? Or something else?

Thanks,
Amit