Most likely, you do not want to do this. You *can* do it, but you are quite likely to suffer from priority inversion (http://en.wikipedia.org/wiki/Priority_inversion)
//Magnus Adam Rich wrote: > 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: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Benjamin Arai > Sent: Saturday, February 10, 2007 6:56 PM > To: pgsql-general@postgresql.org; pgsql-admin@postgresql.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? > > http://archives.postgresql.org/ > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
