Re: Strategies/Best Practises Handling Large Tables

On Thu, Nov 15, 2012 at 1:34 PM, Chitra Creta <chitracreta(at)gmail(dot)com> wrote:

> 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?
>
> Thank you for your ideas.
>

PostgreSQL has COPY TO to export records to a file (
http://wiki.postgresql.org/wiki/COPY ).