Re: "set nice" running a transaction in a lower

Поиск
Список
Период
Сортировка
От Doug Fields
Тема Re: "set nice" running a transaction in a lower
Дата
Msg-id 5.1.0.14.2.20020612135754.02b145f0@pop.pexicom.com
обсуждение исходный текст
Ответ на "set nice" running a transaction in a lower priority?  ("Clark C . Evans" <cce@clarkevans.com>)
Список pgsql-general
On a related topic:

Is it possible to run a background query (I use JDBC)?

For example, I would like to run a query which I know takes a long time to
process, without holding the connection open and/or synchronously waiting
for the query response.

This is related to the "import" because I typically do my import to a temp
table, then INSERT...SELECT into the real table which is very slow because
of all the indexes which have to be handled.

Thanks,

Doug


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

Предыдущее
От: Steve Atkins
Дата:
Сообщение: Re: optimizing SELECT with LIKE
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: optimizing SELECT with LIKE