Thanks for your example Chris. I will look into it as a long-term solution.
Partitioning tables as a strategy worked very well indeed. This will be my short/medium term solution.
Another strategy that I would like to evaluate as a short/medium term solution is archiving old records in a table before purging them.
I am aware that Oracle has a tool that allows records to be exported into a file / archive table before purging them. They also provide a tool to import these records.
Does PostgreSQL have similar tools to export to a file and re-import?
If PostgreSQL does not have a tool to do this, does anyone have any ideas on what file format (e.g. text file containing a table of headers being column names and rows being records) would be ideal for easy re-importing into a PostgreSQL table?
