Обсуждение: Explicit Transaction Priority

Поиск
Список
Период
Сортировка

Explicit Transaction Priority

От
"Alex"
Дата:
Hello..
 
I was wondering if it's possible to make postgresql backend to adjust his priority based by an parameter to begin..
 
i.e:  For linux , a "BEGIN -20"  to renice backend priority to -20..
 
This should be easy (i hope) to implement using setpriority(..) , but there are a few questions.
 
1) How portable is it ?
2) What implications does it have on the postgres backend ?
 
This could be useful in some situations (like logtables  , where I don't need instant inserts or updates..)
 
 
Thanks
    Alex

Re: Explicit Transaction Priority

От
Michael Fuhr
Дата:
On Sat, Mar 05, 2005 at 07:56:16PM +0200, Alex wrote:

> I was wondering if it's possible to make postgresql backend to
> adjust his priority based by an parameter to begin..

This has come up before -- search the list archives to see past
discussion.  Here's a message that sums up the arguments against:

http://archives.postgresql.org/pgsql-general/2004-10/msg00400.php

-- 
Michael Fuhr
http://www.fuhr.org/~mfuhr/