From: | Craig James <cjames(at)emolecules(dot)com> |
---|---|
To: | gnanam(at)zoniac(dot)com |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Database archive solutions |
Date: | 2012-11-21 16:42:01 |
Message-ID: | CAFwQ8rfvoNtqCwsW267RTfhGEchGZGpme9jc4Xbv-kevU0FoHQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Wed, Nov 21, 2012 at 1:21 AM, Gnanakumar <gnanam(at)zoniac(dot)com> wrote:
> 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.
>
Your question isn't specific enough. What does "not compromised" mean?
Every technique for archiving records has some impact on some part of your
system. Is a 0.1% impact too much? A 1% impact? A 10% impact? A factor
of 2 slowdown?
Do you need real-time archiving, a few minutes delay, or once a month
backup?
Do you need a hot standby or records that can be retrieved in a few hours?
You have to describe your needs completely before you can get a meaningful
answer.
Craig
>
> 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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
From | Date | Subject | |
---|---|---|---|
Next Message | Shamim Uddin | 2012-11-22 03:56:53 | FW: [webmaster] Information Required |
Previous Message | Tom Lane | 2012-11-21 14:37:34 | Re: How to check history of sequences and constraints (version 9.1) |