(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


Reply via email to