Обсуждение: Inheritance and Partitioning

Поиск
Список
Период
Сортировка

Inheritance and Partitioning

От
Simon Riggs
Дата:
I'm currently doing the docs for CE & Partitioning.

The ddl.sgml chapter had a section on Inheritance. I'm expanding that
section and splitting it into two:

INHERITANCE & PARTITIONING
   1. Table Partitioning
      Existing chapter, but with more detail of a general nature that
will be important information when we discuss...

   2. Basic Partitioning using Constraint Exclusion
      How to enhance inheritance with constraints to allow CE. How that
works to provide basic partitioning, with examples and long list of
caveats.

Any comments while I'm in progress? You will of course have another
chance to comment when I complete the patch.

Best Regards, Simon Riggs


Re: Inheritance and Partitioning

От
Alvaro Herrera
Дата:
Simon Riggs wrote:
> I'm currently doing the docs for CE & Partitioning.
>
> The ddl.sgml chapter had a section on Inheritance. I'm expanding that
> section and splitting it into two:
>
> INHERITANCE & PARTITIONING
>    1. Table Partitioning
>       Existing chapter, but with more detail of a general nature that
> will be important information when we discuss...
>
>    2. Basic Partitioning using Constraint Exclusion
>       How to enhance inheritance with constraints to allow CE. How that
> works to provide basic partitioning, with examples and long list of
> caveats.

Hmm, sorry, I missed most of the discussion on CE -- is it used only
in inheritance?  Maybe you should add a separate section on
partitioning, referring to the inheritance section where appropiate.
But they are clearly not the same feature.

Also, it will be more clearly separated as we add more partitioning
related features, right?

--
Alvaro Herrera                         Architect, http://www.EnterpriseDB.com
"A wizard is never late, Frodo Baggins, nor is he early.
 He arrives precisely when he means to."  (Gandalf, en LoTR FoTR)

Re: Inheritance and Partitioning

От
Simon Riggs
Дата:
On Sun, 2005-10-09 at 10:56 -0300, Alvaro Herrera wrote:
> Simon Riggs wrote:
> > I'm currently doing the docs for CE & Partitioning.
> >
> > The ddl.sgml chapter had a section on Inheritance. I'm expanding that
> > section and splitting it into two:
> >
> > INHERITANCE & PARTITIONING
> >    1. Table Partitioning
> >       Existing chapter, but with more detail of a general nature that
> > will be important information when we discuss...
> >
> >    2. Basic Partitioning using Constraint Exclusion
> >       How to enhance inheritance with constraints to allow CE. How that
> > works to provide basic partitioning, with examples and long list of
> > caveats.
>
> Hmm, sorry, I missed most of the discussion on CE -- is it used only
> in inheritance?

Regrettably at this time. I couldn't find a clear point to put the code
that would allow it to work cleanly for the UNION ALL case, at least in
the time available.

> Maybe you should add a separate section on
> partitioning, referring to the inheritance section where appropiate.
> But they are clearly not the same feature.
>
> Also, it will be more clearly separated as we add more partitioning
> related features, right?

OK. I'll keep the same flow, just promote both up a level.

So there'll be two <sect1>s for each concept.

Best Regards, Simon Riggs