Hi again, > I understand it and for this reason I said to "use some strategy to purge > old historical data *OR* make your audit tables partitioned"... yes, prepare to scale up in any case, even if it seems to be a remote chance ATM. If the "untouched" nature of this data is so critical, you have no chances to tamper with it in the future, or it will lose its value. On the contrary, being able to scale up to a very large amount of historical data can be sold as a plus to the same audience/market, as you clearly are planning to "think big". If it cannot be partitioned because of budget concerns, a low cost alternative is to print it out and have it authenticated by a notary (since your historical records bear a prog number you clearly cannot hide "sections" in the process). Pretty much what you do with book-keeping. Cheers Bèrto -- ============================== If Pac-Man had affected us as kids, we'd all be running around in a darkened room munching pills and listening to repetitive music. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
