(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.