Query Priority - Mailing list pgsql-performance

From Peter Childs
Subject Query Priority
Date
Msg-id Pine.LNX.4.44.0305021349580.6771-100000@RedDragon.Childs
Whole thread Raw
Responses Re: Query Priority  (Andrew Sullivan <andrew@libertyrms.info>)
Re: Query Priority  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Achilleus Mantzios
Date:
Subject: Re: [SQL] 7.3 analyze & vacuum analyze problem
Next
From: Achilleus Mantzios
Date:
Subject: Re: [SQL] 7.3 analyze & vacuum analyze problem