From: | "Rob Kirkbride" <rob(dot)kirkbride(at)gmail(dot)com> |
---|---|
To: | "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Data Warehousing |
Date: | 2007-09-03 08:48:07 |
Message-ID: | e0b3cb2b0709030148g2a458acft9a5eea3075fc4ee4@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 03/09/07, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> wrote:
>
> On 9/3/07, Rob Kirkbride <rob(dot)kirkbride(at)gmail(dot)com> wrote:
> > Hi,
> >
> > I've got a postgres database collected logged data. This data I have to
> keep
> > for at least 3 years. The data in the first instance is being recorded
> in a
> > postgres cluster. This then needs to be moved a reports database server
> for
> > analysis. Therefore I'd like a job to dump data on the cluster say every
> > hour and record this is in the reports database. The clustered database
> > could be purged of say data more than a week old.
> >
> > So basically I need a dump/restore that only appends new data to the
> reports
> > server database.
> >
> > I've googled but can't find anything, can anyone help?
>
> You might find an answer in partitioning your data. There's a section
> in the docs on it. Then you can just dump the old data from the
> newest couple of partitions if you're partitioning by week, and dump
> anything older with a simple delete where date < now() - interval '1
> week' or something like that.
We're using hibernate to write to the database. Partitioning looks like it
will be too much of a re-architecture. In reply to Andrej we do have a
logged_time entity in the required tables. That being the case how does that
help me with the tools provided?
Might I have to write a custom JDBC application to do the data migration?
Rob
From | Date | Subject | |
---|---|---|---|
Next Message | Andrej Ricnik-Bay | 2007-09-03 09:51:59 | Re: Data Warehousing |
Previous Message | Albe Laurenz | 2007-09-03 08:42:38 | Re: invalid byte sequence for encoding "UTF8": 0xff |