Is there such a thing as a 'background database job'?

Поиск
Список
Период
Сортировка
Искать
От
Mike Nolan
Тема
Is there such a thing as a 'background database job'?
Дата
Msg-id
200508230253.j7N2rKmI018420@gw.tssi.com
Список
Дерево обсуждения
Is there such a thing as a 'background database job'? Mike Nolan <nolan@gw.tssi.com>
Re: Is there such a thing as a 'background database job'? Vivek Khera <vivek@khera.org>
In a recent discussion with an academician friend of mine regarding how
to improve performance on a system, he came up with the idea of taking what
is now a monthly purge/cleanup job that takes about 24 hours (and growing) 
and splitting it up into a series of smaller tasks.

That part's fairly easy, but his next idea was to run those tasks more or
less continuously in the background.

As I understand most database back-ends, including Postgresql, there 
really isn't a way to run queries for an application in the background
(ie, at a lower priority), especially for an application that does updates.

I suppose I could 'nice' the program itself, but would that have any
positive impact?
--
Mike Nolan
В списке pgsql-general по дате отправления
От: Jim C. Nasby
Дата:
Сообщение: Re: Query results caching?
От: Sivakumar K
Дата:
FAQ