Changes
Jump to navigation
Jump to search
Haas PhD Server Configuration (view source)
Revision as of 23:11, 3 November 2011
, 23:11, 3 November 2011→Install and Configure PostgreSQL
This is equivalent to every 512Mb
shared_buffers = 393216 786432 #1gig = 1073741824 => '''131072''' * 8 * 1024, currently trying 3gig6gig The recommendation is to use around 10-15% of RAM, but for a single user db something higher seems better This is in 8K blocks
work_mem = 5242882097152 #In KB, so 1024 * 512=> 262144524288 = 512Mb, note Note that this might be a little too high for aggresively stacked queries But this seems to be the bite point for performance.
maintenance_work_mem = 262144
#786432 => 6 * 1073741824 => 6 * 131072 * 8 * 1024
This is how much VACUUM will use - it doesn't make a huge difference
effective_cache_size = 7864321835008 #In 8k blocks. This is the maximum memory that postgres will allocate. It is currently set to 14Gb.
Alter ''/var/lib/pgsql/data/pg_hba.conf'' to include the lines (under IPv4):
