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.
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