Rene, There is no single answer to this as it depends on your usage, type of data, etc. You can get some pointers here
http://postgis.refractions.net/docs/ch06.html#id2636014 Also a search on the mailing list will give you some information on what to change, some messages are a bit old but they contain valuable information. Hope that helps -- Juan Marín Otero GIS Consultant -------Visita mi blog en--------------------- http://guachintoneando.blogspot.com --------------------------------------------------- On Sun, Nov 6, 2011 at 1:16 PM, René Fournier <m...@renefournier.com> 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 10.7.2 (*not* using OS X Server) > > - PostgreSQL 9.05 > - PostGIS 1.5.3 > - Tiger Geocoder 2010 database (from build scripts from > http://svn.osgeo.org/postgis/trunk/extras/tiger_geocoder/tiger_2010/) > - Database size: ~90GB > > I should say, this box does more than PostgreSQL > geocoding/reverse-geocoding, so reasonably only half of the memory should > be allotted to PostgreSQL. > > Coming from MySQL, I would normally play with the my.cnf, using > my-huge.cnf as a start. But I'm new to PostgreSQL and PostGIS (w/ a big > database), so I was wondering if anyone had suggestions on tuning > parameters (also, which files, etc.) Thanks! > > …Rene > > > _______________________________________________ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > >
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
