Re: "stored procedures" - use cases?

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Josh Berkus" <josh(at)agliodbs(dot)com>,<pgsql-hackers(at)postgresql(dot)org>
Subject: Re: "stored procedures" - use cases?
Date: 2011-04-26 23:08:54
Message-ID: 4DB70A36020000250003CED8@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.

-Kevin

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Josh Berkus 2011-04-26 23:19:33 Re: branching for 9.2devel
Previous Message Kevin Grittner 2011-04-26 23:01:00 Re: "stored procedures" - use cases?