"set nice" running a transaction in a lower priority? - Mailing list pgsql-general

From Clark C . Evans
Subject "set nice" running a transaction in a lower priority?
Date
Msg-id 20020612133316.A69499@doublegemini.com
Whole thread Raw
Responses Re: "set nice" running a transaction in a lower  (Doug Fields <dfields-pg-general@pexicom.com>)
Re: "set nice" running a transaction in a lower priority?  (Richard Huxton <dev@archonet.com>)
List pgsql-general
I was wondering if there is a way to set transaction
priority so that it takes its good sweet time and
handles other queries quickly?  I have an "import"
process that takes a while, and I don't mind having
the user who is doing the import wait; but it would
be nice to have the box more responsive while the
import is occuring.

Best,

Clark

pgsql-general by date:

Previous
From: "Tom Burke"
Date:
Subject: Re: Updates are slow..
Next
From: Bruce Momjian
Date:
Subject: Re: [BUGS] createdb comments