|
| 1 | +#*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*= |
| 2 | +# pg_geqo * |
| 3 | +# ------- = |
| 4 | +# * |
| 5 | +# Example Genetic Algorithm config file = |
| 6 | +# for the PostgreSQL * |
| 7 | +# Genetic Query Optimization (GEQO) module = |
| 8 | +# * |
| 9 | +#*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*= |
| 10 | +# Martin Utesch * Institute of Automatic Control * |
| 11 | +# = University of Mining and Technology = |
| 12 | +# utesch@aut.tu-freiberg.de * Freiberg, Germany * |
| 13 | +#*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*= |
| 14 | + |
| 15 | +# this file should be '$PGDATA/pg_geqo', but it doesn't have |
| 16 | +# to exist |
| 17 | + |
| 18 | +# comment character is '#' |
| 19 | +# |
| 20 | +# separator between recognized tag and possible value |
| 21 | +# must be white space |
| 22 | + |
| 23 | +# qs: means query size, which is the number of relations |
| 24 | +# contained in a query |
| 25 | + |
| 26 | +#=================+===================+=============================+ |
| 27 | +# RECOGNIZED TAGS | POSSIBLE VALUES | DEFAULTS | |
| 28 | +#=================+===================+=============================+ |
| 29 | +# 'Pool_Size' | positive int | 2^(qs+1) | |
| 30 | +#-----------------+-------------------+-----------------------------+ |
| 31 | +# 'Effort' | [low,medium,high] | medium | |
| 32 | +#-----------------+-------------------+-----------------------------+ |
| 33 | +# 'Generations' | positive int | 'Effort' * log2('Pool_Size')| |
| 34 | +#-----------------+-------------------+-----------------------------+ |
| 35 | +# 'Selection_Bias'| [1.50; 2.00] | 2.0 | |
| 36 | +#-----------------+-------------------+-----------------------------+ |
| 37 | +# 'Random_Seed' | positive long | time(NULL) | |
| 38 | +#=================+===================+=============================+ |
| 39 | + |
| 40 | +# 'Pool_Size' is essential for the genetic algorithm performance. |
| 41 | +# It gives us the number of individuals within one population. |
| 42 | +# |
| 43 | +# 'Effort' 'low' means integer value of 1, 'medium' 40, and 'high' 80. |
| 44 | +# |
| 45 | +# 'Generations' gives us the stopping criterion for the number |
| 46 | +# of iterations within the genetic algorithm. |
| 47 | +# |
| 48 | +# 'Selection_Bias' gives us the selective pressure within the |
| 49 | +# population. |
| 50 | +# |
| 51 | +# 'Random_Seed' is the random seed for the random() function. |
| 52 | +# You don't have to set it. |
| 53 | + |
| 54 | +# All parameters will be computed within the GEQO module when they |
| 55 | +# are not set in the pg_geqo file. |
| 56 | + |
| 57 | + |
| 58 | +# Example pg_geqo settings: |
| 59 | +# |
| 60 | +#Pool_Size 128 |
| 61 | +#Effort low |
| 62 | +#Generations 200 |
| 63 | +#Random_Seed 830518260 |
| 64 | +#Selection_Bias 1.750000 |