On Thu, Jan 3, 2013 at 2:50 PM, Rich Shepard <rshep...@appl-ecosys.com> wrote: > > There should not be many changes in these tables.
Ok. > > And historical data > cannot be purged or the purpose of maintaining a history is lost. The > history is valuable for tracking changes over time in regulatory agency > staff and to prevent data manipulation such as was done several years ago by > the president of Southwestern Resources (a gold mining company) to pump up > the company's stock price by changing assay results. I understand it and for this reason I said to "use some strategy to purge old historical data *OR* make your audit tables partitioned"... regards, -- Fabrízio de Royes Mello Consultoria/Coaching PostgreSQL >> Blog sobre TI: http://fabriziomello.blogspot.com >> Perfil Linkedin: http://br.linkedin.com/in/fabriziomello >> Twitter: http://twitter.com/fabriziomello