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
--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
