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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general pgsql-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

Browse pgsql-admin by date

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

Browse pgsql-general by date

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

Browse pgsql-hackers by date

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