[postgis-users] Tuning PostgreSQL for a very large database

[Juan Marín Otero]

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 <m5 at 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 at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20111107/a124cfcb/attachment.html>