Database archive solutions

Поиск
Список
Период
Сортировка
От Gnanakumar
Тема Database archive solutions
Дата
Msg-id 014101cdc7c9$a73bcb00$f5b36100$@zoniac.com
обсуждение исходный текст
Ответы Re: Database archive solutions
Список 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



В списке pgsql-admin по дате отправления:

Предыдущее
От: Shams Khan
Дата:
Сообщение: How to check history of sequences and constraints (version 9.1)
Следующее
От: Tom Lane
Дата:
Сообщение: Re: How to check history of sequences and constraints (version 9.1)