On Wednesday 21 October 2009 01:23:18 am Ivano Luberti wrote: > The problem is how you use those data ? > I have used schemas to split data when I had to manage large amount of > data (hundred of thousand records) that are (almost) never going to be > used together, if not for statistic purposes and offline processing. > > If you never need to select those data all together (different companies > and instances access only their own data) and the amount is really large > than you can have benefit from splitting, otherwise adding a field is > going to be more efficient. I don't see any one company having much more than 50 Gigs. So I'm not to worried about the size. But I do see wanting to create aggreate type reports of the companies (like a HQ wanting to report an aggreate GL report of the companies). I would think both the using company_id column or using schemas to separate the companies would allow easy access for the aggreate type reports. Food for thought, Johnf -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
