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

Browse pgsql-hackers by date

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