Strabon

changeset 1147:5a954ddd0a91

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