On Thu, 3 Jan 2013, Fabrízio de Royes Mello wrote:
And keep in mind that kind of table tend to grow quickly, so you must use some strategy to purge old historical data or make your audit table partitioned...
Fabrizio, There should not be many changes in these tables. 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. Rich -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general