Skip site navigation (1) Skip section navigation (2)

Explicit Transaction Priority

From: "Alex" <alexcos(at)dristor(dot)ro>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: Explicit Transaction Priority
Date: 2005-03-05 17:56:16
Message-ID: 002f01c521ac$a15dfcb0$6400a8c0@alexxp (view raw or flat)
Thread:
Lists: pgsql-hackers
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

Responses

pgsql-hackers by date

Next:From: Simon RiggsDate: 2005-03-05 18:03:17
Subject: Re: 8.0.X and the ARC patent
Previous:From: Michael FuhrDate: 2005-03-05 17:05:27
Subject: Re: Manual vs automatic functionality

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group