Обсуждение: Explicit Transaction Priority

Поиск

Список

Период

Сортировка

Explicit Transaction Priority

От

"Alex"

Дата:

05 марта 2005 г., 17:56:17

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

Re: Explicit Transaction Priority

От

Michael Fuhr

Дата:

05 марта 2005 г., 20:16:28

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/

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

Обсуждение: Explicit Transaction Priority

Explicit Transaction Priority

Re: Explicit Transaction Priority