Changes
Jump to navigation
Jump to search
shared_buffers = 131072
#1073741824 => 131072 * 8 * 1024
Haas PhD Server Configuration (view source)
Revision as of 17:27, 16 July 2011
, 17:27, 16 July 2011→Package additions/upgrades/removals
yum install glib glib2 libpng libjpeg libtiff ghostscript freetype ImageMagick ImageMagick-perl
===On PgsqlPostgres.Haas===
====Removing Unneeded Servers====
model name: Intel(R) Xeon(TM) CPU 2.80GHz
Review the performance tuning section on the [[Working with PostgreSQL]] page , and possibly on [http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server the official quick guide page] and make the following changes to ''/var/lib/pgsql/data/postgresql.conf'':
listen_addresses = '*'
port = 5432
checkpoint_segments=32 This is equivalent to every 512Mb shared_buffers = 393216 #1gig = 1073741824 => '''131072''' * 8 * 1024, currently trying 3gig work_mem = 262144524288 #1024 * 256 512=> 262144, note that this might be a little too high for aggresively stacked queries
maintenance_work_mem = 262144
