Re: [ADMIN] query priority

2002-01-08 Thread Peter Eisentraut
Peter T. Brown writes: > Is there a way to reduce the priority of any psql queries depending on the > user connecting to the database? Officially: No. Most ideas to this end have been a failure, because the low-priority query might hold locks that the high-priority query needs, so merely "nice"

[ADMIN] query priority

2002-01-08 Thread Peter T. Brown
Is there a way to reduce the priority of any psql queries depending on the user connecting to the database? I basically want to be able to run lower priority queries for some types of queries (for exporting and analysis) while other queries run at higher priorities (for mission critical website se