>> > 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
