Explicit Transaction Priority

Started by Alexalmost 21 years ago2 messages
#1Alex
alexcos@dristor.ro

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

#2Michael Fuhr
mike@fuhr.org
In reply to: Alex (#1)
Re: Explicit Transaction Priority

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/