[CLUE-Tech] Postgres tuning

[Grant Johnson]

Hey, all, especially Scott, I did some tweaks.  With little load, 
queries are slightly slower (less than hals a second different) but I am 
hoping for better performance with many users.  Tell me what you think 
of the tweaks....

#
# 
Optimizer Parameters
#
#enable_seqscan = true
#enable_indexscan = true
#enable_tidscan = true
#enable_sort = true
#enable_nestloop = true
#enable_mergejoin = true
#enable_hashjoin = true

#ksqo = false
#geqo = true

#effective_cache_size = 1000  # default in 8k pages
#random_page_cost = 4
#cpu_tuple_cost = 0.01
#cpu_index_tuple_cost = 0.001
#cpu_operator_cost = 0.0025
cpu_tuple_cost = 0.1                  #tweaked
cpu_index_tuple_cost = 0.00001        #tweaked
cpu_operator_cost = 0.025             #tweaked
#geqo_selection_bias = 2.0 # range 1.5-2.0



#
# 
Write-ahead log (WAL)
#
#wal_buffers = 8 # min 4
wal_files = 32 # range 0-64                  #tweaked
commit_delay = 500 # range 0-100000          #tweaked