Strabon

changeset 1147:5a954ddd0a91

find changesets by author, revision, files, or words in the commit message
Added some information at the Postgres tuning section of the README file.
Increase the values for the 'from_collapse_limit' and 'join_collapse_limit' parameters.
For more information, see http://www.postgresql.org/docs/9.1/static/explicit-joins.html.
author Kostis Kyzirakos <kkyzir@di.uoa.gr>
date Sat May 04 14:32:22 2013 +0300 (2013-05-04)
parents 0d370b75a8b9
children 1f72d6d553bc
files README
line diff
     1.1 --- a/README	Fri May 03 20:07:41 2013 +0300
     1.2 +++ b/README	Sat May 04 14:32:22 2013 +0300
     1.3 @@ -229,6 +229,13 @@
     1.4  #random_page_cost = 1.3 #1.1-2.0
     1.5  ## SSD array
     1.6  #random_page_cost = 2.0 #1.5-2.5
     1.7 +### Planner options
     1.8 +# Increase the following values in order to avoid using the GEQO planner. 
     1.9 +# Small values (<8) reduce planning time but may produce inferior query plans
    1.10 +# 
    1.11 +geqo_threshold = 15 # keep this value larger that the following two parameters
    1.12 +from_collapse_limit = 14
    1.13 +join_collapse_limit = 14
    1.14  ### Misc
    1.15  default_statistics_target    = 10000 
    1.16  constraint_exclusion         = on