Quick Links

Explicit Transaction Priority

Lists:	pgsql-hackers

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
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

From:	Michael Fuhr <mike(at)fuhr(dot)org>
To:	Alex <alexcos(at)dristor(dot)ro>
Cc:	pgsql-hackers(at)postgresql(dot)org
Subject:	Re: Explicit Transaction Priority
Date:	2005-03-05 20:16:08
Message-ID:	20050305201608.GB70847@winnie.fuhr.org
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Lists:	pgsql-hackers

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: