[Bizgres-general] [ENG] Re: Statement Queuing take II - Resource Scheduling (Running with cost and cursors)

[Jim C. Nasby]

On Fri, Aug 04, 2006 at 10:40:51AM -0500, Jim C. Nasby wrote:
> > I guess we were all thinking along the lines of "users mainly do one 
> > type of workload" (which is true in some cases anyway), but clearly in 
> > cases where user x does several different types of workload (e.g. on 
> > Mondays does data mining and then daily reporting the other days....) 
> > what you are describing will work better.
> 
> There's probably room for both. IIRC, Oracle's resource management is
> based on limiting what individual users can do. I'm not trying to play
> 'follow the leader' here, but presumably if they put the effort into
> doing that there's some demand.

Sorry for the noise, but I thought of a real-world use case (it would be
a good idea to find more of these).

We have a customer that runs a mixed OLTP/OLAP environment. They have
data coming in from various sources (mostly as log files). That data
needs to be processed into the system, and it's pretty important that
that processing doesn't fall behind.

Once the data is in the system, there's various forms of analysis that
needs to happen to it, much of which involves aggregating across a days
worth of data, etc.

So, in this case, it would be useful if the analysis stuff (some of
which comes in as ad-hoc queries from the web) could be controlled so
that it doesn't impact the log processing. Since these things happen
using different users/roles, that would provide an easy means to do so.

(As it stands, this client had to write their own batch processing
system that gives priority to the log processing.)
-- 
Jim C. Nasby, Sr. Engineering Consultant      jnasby at pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461