Viewing Running Postgres Queries (and what if they are too long??)

There can be many times when knowing what queries are currently running on a Postgres server can be helpful to know.  It is pretty well known that the system pg_stat_activity table can get you this information.  Just run the following query: SELECT * FROM pg_stat_activity; The resulting record set contains a bunch of information but …

Our Application Server Stack

With a new year coming up I thought I would give a quick run down of our OS server stack.  From the beginning SpatialKey has been built on a number of great community/company open source platforms, here is what we currently use: Apache/Tomcat We are currently evaluating moving our application servers to pure Tomcat vs. …