Database archive solutions

From: "Gnanakumar" <gnanam(at)zoniac(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Database archive solutions
Date: 2012-11-21 09:21:51
Message-ID: 014101cdc7c9$a73bcb00$f5b36100$@zoniac.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

Our application requirement demands archiving of records, so that
performance/speed of the application is not compromised. So, am looking
out/evaluating on various techniques/solutions available for database
archiving, in general, for PostgreSQL.

Few solutions that comes to my mind are:

1) Table partitioning
2) Separate tablespace and/or schema
3) Moving archived records/tables to a different harddisk

Any other suggestions/pointers/solutions are really welcome and appreciated.

NOTE: We're running PostgreSQL v9.1.3 on CentOS5.2

Regards,
Gnanam

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2012-11-21 14:37:34 Re: How to check history of sequences and constraints (version 9.1)
Previous Message Shams Khan 2012-11-21 07:02:50 How to check history of sequences and constraints (version 9.1)