Re: [GENERAL] Tuning PostgreSQL for very large database

2011-11-06 Thread John R Pierce
On 11/06/11 8:51 AM, René Fournier wrote: Just wondering what I can do to squeeze out more performance of my database application? Here's my configuration: - Mac mini server - Core i7 quad-core at 2GHz - 16GB memory - Dedicated fast SSD (two SSDs in the server) - Mac OS X

[GENERAL] Tuning PostgreSQL for very large database

2011-11-06 Thread René Fournier
Just wondering what I can do to squeeze out more performance of my database application? Here's my configuration: - Mac mini server - Core i7 quad-core at 2GHz - 16GB memory - Dedicated fast SSD (two SSDs in the server) - Mac OS X 10.7.2 (*not* using OS X Server) - PostgreSQL 9.05 - PostGIS 1.5.3