Postgres Pro
Downloads
Home   >   mailing lists

Database archive solutions - Mailing list pgsql-admin

From Gnanakumar
Subject Database archive solutions
Date
Msg-id 014101cdc7c9$a73bcb00$f5b36100$@zoniac.com
Whole thread Raw
Responses Re: Database archive solutions
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: Shams Khan
Date:
Subject: How to check history of sequences and constraints (version 9.1)
Next
From: Tom Lane
Date:
Subject: Re: How to check history of sequences and constraints (version 9.1)