Postgres Pro
Downloads
Home   >   mailing lists

Thread: Explicit Transaction Priority

Explicit Transaction Priority

From
"Alex"
Date:
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

From
Michael Fuhr
Date:
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/