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
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
