On Apr 26, 2011, at 6:08 PM, Kevin Grittner wrote: > Josh Berkus <j...@agliodbs.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 j...@nasby.net 512.569.9461 (cell) http://jim.nasby.net -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
