From: Josh Berkus <josh@agliodbs.com>
To: daniel.haensse@swissembedded.com
Cc: pgsql-performance@postgresql.org
Cc: rm_pg@cheapcomplexdevices.com
Subject: Re: Transaction prioritization from java possible?
Date: Mon, 14 May 2007 10:22:03 -0700
Message-ID: <200705141022.04177.josh@agliodbs.com> (raw)
In-Reply-To: <4646DD95.40906@swissembedded.com>
References: <4646DD95.40906@swissembedded.com>
Daniel,
> basically we have a transactional web application. The users can browse
> through some entries in the database and start a bunch of heavy queries
> that take up to 15 minutes (if multiple such heavy queries run in
> parallel the performance of the database and webinterface drops very
> quickly). The easiest thing will be to serialize these heavy queries and
> run it in the background. I can do this from the tomcat server.
> Now I would like to prioritize the webinterface user interaction over
> these heavy queries. How can I implement this from java?
>
> Ron mentioned this paper (see
> http://www.nabble.com/Background-vacuum-t3719682.html )
>
> And I finally found this:
> http://weblog.bignerdranch.com/?p=11
>
> Is there an easier way from java?
Check out the Bizgres project (www.bizgres.org). They currently have a
query-queuing system which will eventually be a contrib to mainstream
PostgreSQL, but you should be able to use it for development right now.
--
--Josh
Josh Berkus
PostgreSQL @ Sun
San Francisco
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: josh@agliodbs.com, daniel.haensse@swissembedded.com, rm_pg@cheapcomplexdevices.com
Subject: Re: Transaction prioritization from java possible?
In-Reply-To: <200705141022.04177.josh@agliodbs.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox