Query Priority

From: Peter Childs <blue(dot)dragon(at)blueyonder(dot)co(dot)uk>
To: pgsql-performance(at)postgresql(dot)org
Subject: Query Priority
Date: 2003-05-02 12:55:01
Message-ID: Pine.LNX.4.44.0305021349580.6771-100000@RedDragon.Childs
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Andrew Sullivan 2003-05-02 14:05:44 Re: Query Priority
Previous Message Rajesh Kumar Mallah 2003-05-01 14:59:16 Re: profiling plpgsql functions..