(On the GENERAL list) Kamil Srot wrote:
Kynn Jones wrote:
I'm hoping to get some advice on a design question ...
...we use pgsql partitioning for other reasons
and it has some of the features you want (data separation, query
performance, ...).
It can be worth reading:
http://www.postgresql.org/docs/8.2/interactive/ddl-partitioning.html
I'm not sure the tip is really what the OP is going to need -- I think
he has a different problem in mind than that addresses -- but after a
quick R of TFM, all I can say is HOLY CR** THAT IS COOL! Postrgresql was
amazing when I first started using it at 7.2, and I'm continually
astounded by learning new features and techniques made available by the
continuing work of the development team.
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate