Home > mailing lists

Explicit Transaction Priority - Mailing list pgsql-hackers

From	Alex
Subject	Explicit Transaction Priority
Date	March 5, 2005 20:56:17
Msg-id	002f01c521ac$a15dfcb0$6400a8c0@alexxp Whole thread Raw
Responses	Re: Explicit Transaction Priority (Michael Fuhr <mike@fuhr.org>)
List	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

From: Michael Fuhr
Date: 05 March 2005, 20:05:41
Subject: Re: Manual vs automatic functionality

From: Simon Riggs
Date: 05 March 2005, 21:11:42
Subject: Re: 8.0.X and the ARC patent