Re: Priorities for users or queries?
От | Adam Rich |
---|---|
Тема | Re: Priorities for users or queries? |
Дата | |
Msg-id | 000001c74da2$a9a4a990$6400a8c0@dualcore обсуждение исходный текст |
Ответ на | Priorities for users or queries? (Benjamin Arai <benjamin@araisoft.com>) |
Ответы |
Re: Priorities for users or queries?
|
Список | pgsql-general |
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@postgresql.org [mailto:pgsql-general-owner@postgresql.org] 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/
В списке pgsql-general по дате отправления: