[Maps-l] PostGIS Terminal

Stephan Knauss toolserver at stephans-server.de
Tue Mar 8 20:10:57 UTC 2011


Hi Thomas,

On 08.03.2011 16:47, Thomas Ineichen wrote:
> - Is it ok to run that on a public toolserver-website, as it gives
> access to the whole database?
the tool is a nice query-builder. But it's quite easy to create 
long-running queries with it. That might kill the DB.

Perhaps it could help to implement a session handling so only a single 
query is running at a time while the rest is waiting in a queue.

Could you implement some logging of the query duration? It could give an 
indication how much load it will put on the DB.

Stephan



More information about the Maps-l mailing list