>> > 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.
This IS bad news. It would mean a serious change in the ETL.
I think I can solve the other problems, but I don't know about this one...
Regards,
Matt