From: | "Gnanakumar" <gnanam(at)zoniac(dot)com> |
---|---|
To: | "'Craig James'" <cjames(at)emolecules(dot)com> |
Cc: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Database archive solutions |
Date: | 2012-11-22 06:03:19 |
Message-ID: | 00de01cdc877$15dcfcc0$4196f640$@zoniac.com |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
> 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?
Sorry if my original question has not clearly conveyed my requirement.
First, let me accept that I'm not a good DBA Expert (am a beginner), however
I'm trying to learn things.
Actually, am finding out various techniques/options *itself* available for
archiving database records. Based on the techniques available, I can
see/assess on how much it could impact our application, so that I can choose
one and adopt that suits our needs. In fact your response was an eye-opener
for me to think further in detail.
> Do you need real-time archiving, a few minutes delay, or once a month
backup?
Yes, we're looking for real-time archiving. Once the records are archived,
Users in the application should able to perform search within archives also
after few minutes of time.
> Do you need a hot standby or records that can be retrieved in a few hours?
It would be helpful if you can share the techniques/options available for
hot standby also.
From | Date | Subject | |
---|---|---|---|
Next Message | Anibal David Acosta | 2012-11-22 15:36:42 | timezone, how postgres deal with it? |
Previous Message | Shamim Uddin | 2012-11-22 03:56:53 | FW: [webmaster] Information Required |