On Apr 26, 2011, at 6:08 PM, Kevin Grittner wrote:
> Josh Berkus <josh(at)agliodbs(dot)com> wrote:
>> -- doing a backfill operation for 10GB of computed data, taking 8
>> hours, where I don't want to hold a transaction open for 8 hours
>> since this is a high-volume OLTP database.
> Been there, done that. Definitely not a rare use case.
We do that so often we've actually written a framework around it and are working on a daemon that will deal with any backfills that have been registered in the system. If we could control transactions that daemon could be entirely in the database... but since we can't, we have to write it in another language outside the database and switch back and forth between the two worlds.
Jim C. Nasby, Database Architect jim(at)nasby(dot)net
512.569.9461 (cell) http://jim.nasby.net
In response to
pgsql-hackers by date
|Next:||From: Joshua Berkus||Date: 2011-04-29 15:19:15|
|Subject: Re: branching for 9.2devel|
|Previous:||From: Magnus Hagander||Date: 2011-04-29 15:14:10|
|Subject: Re: Changing the continuation-line prompt in psql?|