Skip site navigation (1) Skip section navigation (2)

Priorities for users or queries?

From: Benjamin Arai <benjamin(at)araisoft(dot)com>
To: pgsql-general(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org
Subject: Priorities for users or queries?
Date: 2007-02-11 00:56:21
Message-ID: 45CE69B5.40204@araisoft.com (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-generalpgsql-hackers
Hi,

Is there a way to give priorities to queries or users?  Something 
similar to NICE in Linux.  My goal is to give the updating (backend) 
application a very low priority and give the web application a high 
priority to avoid disturbing the user experience.

Thanks in advance!

Benjamin


Responses

pgsql-hackers by date

Next:From: Rick GiggerDate: 2007-02-11 01:13:45
Subject: Re: 10 weeks to feature freeze (Pending Work)
Previous:From: Jeremy DrakeDate: 2007-02-11 00:08:33
Subject: Re: patch adding new regexp functions

pgsql-admin by date

Next:From: Joshua D. DrakeDate: 2007-02-11 03:06:10
Subject: Re: Priorities for users or queries?
Previous:From: Benjamin AraiDate: 2007-02-11 00:49:06
Subject: Problem indexing large database with large number of inserts (partial index building?)

pgsql-general by date

Next:From: Joshua D. DrakeDate: 2007-02-11 03:06:10
Subject: Re: Priorities for users or queries?
Previous:From: Benjamin AraiDate: 2007-02-11 00:49:06
Subject: Problem indexing large database with large number of inserts (partial index building?)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group