Re: Priority to a mission critical transaction

Поиск
Список
Период
Сортировка
От Brad Nicholson
Тема Re: Priority to a mission critical transaction
Дата
Msg-id 1164314415.21439.32.camel@dba5.int.libertyrms.com
обсуждение исходный текст
Ответ на Priority to a mission critical transaction  ("Carlos H. Reimer" <carlos.reimer@opendb.com.br>)
Ответы Re: Priority to a mission critical transaction  ("Jim C. Nasby" <jim@nasby.net>)
Список pgsql-performance
On Tue, 2006-11-21 at 21:43 -0200, Carlos H. Reimer wrote:
> Hi,
>
> We have an application that is mission critical, normally very fast,
> but when an I/O or CPU bound transaction appears, the mission critical
> application suffers. Is there a way go give some kind of priority to
> this kind of application?
> Reimer


Not that I'm aware of.  Depending on what the problems transactions are,
setting up a replica on a separate machine and running those
transactions against the replica might be the solution.

--
Brad Nicholson  416-673-4106
Database Administrator, Afilias Canada Corp.


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

Предыдущее
От: Greg Smith
Дата:
Сообщение: Re: Direct I/O issues
Следующее
От: "Gopal"
Дата:
Сообщение: Postgres scalability and performance on windows