Re: Data Warehousing - Mailing list pgsql-general

From Rob Kirkbride
Subject Re: Data Warehousing
Date
Msg-id 46DBDB09.1070906@gmail.com
Whole thread Raw
In response to Re: Data Warehousing  ("Andrej Ricnik-Bay" <andrej.groups@gmail.com>)
Responses Re: Data Warehousing
List pgsql-general
Andrej Ricnik-Bay wrote:
> On 9/3/07, Rob Kirkbride <rob.kirkbride@gmail.com> wrote:
>
>
>> 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?
>>
> That would be one option :}
>
> If the server is on a Unix/Linux-platform you should be able
> to achieve the result with a reasonably simple shell-script
> and cron, I'd say.
>
>
I am on a Linux platform but I'm going to need some pointers regarding
the cron job. Are you suggesting that I parse the dump file? I assume I
would need to switch to using inserts and then parse the dump looking
for where I need to start from?




pgsql-general by date:

Previous
From: "Andrej Ricnik-Bay"
Date:
Subject: Re: Data Warehousing
Next
From: Gregory Stark
Date:
Subject: Re: Instances where enable_seqscan = false is good