Benjamin Arai wrote: > 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!
You might want to look at the following, as they mention a PostgreSQL prototype: http://www.cs.cmu.edu/~natassa/aapubs/conference/priority mechanisms.pdf Regards, -- Jose Orlando Pereira ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq