From: | "Adam Rich" <adam(dot)r(at)sbcglobal(dot)net> |
---|---|
To: | "'Benjamin Arai'" <benjamin(at)araisoft(dot)com>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Priorities for users or queries? |
Date: | 2007-02-11 06:05:42 |
Message-ID: | 000001c74da2$a9a4a990$6400a8c0@dualcore |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general pgsql-hackers |
There is a function pg_backend_pid() that will return the PID for
the current session. You could call this from your updating app
to get a pid to feed to the NICE command.
-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Benjamin Arai
Sent: Saturday, February 10, 2007 6:56 PM
To: pgsql-general(at)postgresql(dot)org; pgsql-admin(at)postgresql(dot)org
Subject: [GENERAL] Priorities for users or queries?
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
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua D. Drake | 2007-02-11 06:45:53 | Re: Priorities for users or queries? |
Previous Message | Benjamin Arai | 2007-02-11 05:41:03 | Re: Priorities for users or queries? |
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua D. Drake | 2007-02-11 06:45:53 | Re: Priorities for users or queries? |
Previous Message | Benjamin Arai | 2007-02-11 05:41:03 | Re: Priorities for users or queries? |
From | Date | Subject | |
---|---|---|---|
Next Message | J. Andrew Rogers | 2007-02-11 06:14:42 | Re: Acclerating INSERT/UPDATE using UPS |
Previous Message | Hideyuki Kawashima | 2007-02-11 06:04:43 | Re: Acclerating INSERT/UPDATE using UPS |