From: | Moshe Jacobson <moshe(at)neadwerx(dot)com> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Need solution for weekly database "snapshot" |
Date: | 2013-04-22 15:58:58 |
Message-ID: | CAJ4CxLmJYyJCbb5iu06HdsnwLnk4zrb=DabEPoDhMsthj523NQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
We have a report in our system that is pulled many times each week, but
needs to be based off data from Sunday at noon. So every Sunday at noon, we
back up our main database and restore it into a new reporting snapshot
database.
The problem is that backing up and restoring the database every week is a
very costly operation that can take many hours. It brings the system to its
knees.
Unfortunately the report touches a lot of the database, so it would be
unreasonable to try to add versioning to the data the report pulls.
Is there an easier way of maintaining a snapshot of our database that can
be accessed throughout the week?
Thanks for any suggestion.
--
Moshe Jacobson
Nead Werx, Inc. | Manager of Systems Engineering
2323 Cumberland Parkway, Suite 201 | Atlanta, GA 30339
moshe(at)neadwerx(dot)com | www.neadwerx.com
"Quality is not an act, it is a habit." -- Aristotle
From | Date | Subject | |
---|---|---|---|
Next Message | Karsten Hilbert | 2013-04-22 16:14:45 | Re: Need solution for weekly database "snapshot" |
Previous Message | Alfonso Afonso | 2013-04-22 15:57:16 | Re: using text search |