[postgis-users] optimizing postgresql memory to speed up queries

[Randy.Goss at kimley-horn.com]

Check out some of the following links.  Although some are getting a
little dated, these should provide you with good strategies for
optimizing your server.

http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html

http://www.phpbuilder.com/columns/smith20010821.php3

http://techdocs.postgresql.org/techdocs/pgsqldbtuning.php

http://www.lyris.com/lm_help/6.0/tuning_postgresql.html


Randy Goss
Kimley-Horn and Associates, Inc.
(904) 998-2084


-----Original Message-----
From: Robert W. Burgholzer [mailto:rburghol at vt.edu] 
Sent: Thursday, January 08, 2004 9:09 AM
To: PostGIS Users Discussion
Subject: [postgis-users] optimizing postgresql memory to speed up
queries


This may be more a postgresql question than postgis, but, does anyone
have any 
good tips for postgresql settings which will enable the server to hum??

I have a server with 2 Gig of Ram and a 2 Gig processor, but am clueless
as to 
the proper settings to help optimize. It is a dedicated GIS server.

Thanks in advance,
r.b.

Robert W. Burgholzer
rburghol at veetee dot edu
History of Nutrition: "Buddha probably consumed a high-carb diet."


_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users