Re:

Hi,

On Fri, Jan 21, 2005 at 09:50:46AM +0100, Matt Casters wrote:
>
> > Some people have been doing it using a union view. There isn't actually
> > a partition feature.
>
> Actually, there is.  If found this example on pgsql-performance:
>
> >>   CREATE TABLE super_foo ( partition NUMERIC, bar NUMERIC );
> >>   ANALYZE super_foo ;
> >>
> >>   CREATE TABLE sub_foo1 () INHERITS ( super_foo );
[...]
> >>
> >>   CREATE TABLE sub_foo2 () INHERITS ( super_foo );
[...]
> >>

Yes, this could be used instead of a view. But there is one thing
missing. You can't just insert into super_foo and aquire the "correct
partition". You will still have to insert into the correct underlying
table. "Real" partitioning will take care of correct partition
selection.

Regards,
Yann