Configuration Tuning for PostgreSQL 9.1 PostGIS 1.5 Ubuntu 12.04 Server
- by Martin
My server performance is poor. At times SSH, top, and other features or commands are very slow to respond, taking several seconds or more. A query that normally takes 5 minutes can sometimes take 30 minutes. The database is mostly being used to do a spatial query (grid and summarize) on approximately 500GB of stored data spread between 4 tables.…