Query Priority

Поиск
Список
Период
Сортировка
От Peter Childs
Тема Query Priority
Дата
Msg-id Pine.LNX.4.44.0305021349580.6771-100000@RedDragon.Childs
обсуждение исходный текст
Ответы Re: Query Priority  (Andrew Sullivan <andrew@libertyrms.info>)
Re: Query Priority  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
    Is there some way to give some postgres backends higher priority.
Hence on a very busy server "important" queries get done faster than less
priority that unimportant queries.
    I don't think this would be too difficult to do as certainly on
Linux the process could just be reniced and the os left to figure it out.
of course any query that is holding up another query with locks needs to
get done quickly.
    I find my self with a database thats slowed to a craw because of a
slow batch program it not letting the gui clients the speed they require
to be usable.

Peter Childs


В списке pgsql-performance по дате отправления:

Предыдущее
От: Achilleus Mantzios
Дата:
Сообщение: Re: [SQL] 7.3 analyze & vacuum analyze problem
Следующее
От: Achilleus Mantzios
Дата:
Сообщение: Re: [SQL] 7.3 analyze & vacuum analyze problem