Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commit795f6ca

Browse files
committed
Update commentary in sample GEQO config file.
1 parentb2f14e1 commit795f6ca

File tree

1 file changed

+17
-9
lines changed

1 file changed

+17
-9
lines changed

‎src/backend/optimizer/geqo/pg_geqo.sample

Lines changed: 17 additions & 9 deletions
Original file line numberDiff line numberDiff line change
@@ -12,27 +12,30 @@
1212
# utesch@aut.tu-freiberg.de * Freiberg, Germany *
1313
#*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=
1414

15-
# this file should be '$PGDATA/pg_geqo', but it doesn't have
16-
# to exist
15+
# To make this file do something, copy it to '$PGDATA/pg_geqo'
16+
# and edit parameters to taste.
17+
# If '$PGDATA/pg_geqo' doesn't exist, the system will use default parameters.
18+
# The file is re-read for every GEQO optimization, if it does exist.
1719

1820
# comment character is '#'
1921
#
2022
# separator between recognized tag and possible value
2123
# must be white space
2224

23-
#qs: means query size, which is the number of relations
25+
#QS: means query size, which is the number of relations
2426
# contained in a query
2527

2628
#=================+===================+=============================+
2729
# RECOGNIZED TAGS | POSSIBLE VALUES | DEFAULTS |
2830
#=================+===================+=============================+
29-
# 'Pool_Size' | positive int | 2^(qs+1) |
31+
# 'Pool_Size' | positive int | 2^(QS+1), but not less than |
32+
# | | 128 nor more than 1024. |
3033
#-----------------+-------------------+-----------------------------+
3134
# 'Effort' | [low,medium,high] | medium |
3235
#-----------------+-------------------+-----------------------------+
33-
# 'Generations' | positive int |'Effort' * log2('Pool_Size')|
36+
# 'Generations' | positive int | Effort * log2(Pool_Size)|
3437
#-----------------+-------------------+-----------------------------+
35-
# 'Selection_Bias'| [1.50;2.00] | 2.0 |
38+
# 'Selection_Bias'| [1.50 ..2.00] | 2.0 |
3639
#-----------------+-------------------+-----------------------------+
3740
# 'Random_Seed' | positive long | time(NULL) |
3841
#=================+===================+=============================+
@@ -41,15 +44,20 @@
4144
# It gives us the number of individuals within one population.
4245
#
4346
# 'Effort' 'low' means integer value of 1, 'medium' 40, and 'high' 80.
47+
# Note: Effort is *only* used to derive a default value for Generations
48+
# --- if you specify Generations then Effort does not matter.
4449
#
45-
# 'Generations' gives us the stopping criterion for the number
46-
# of iterations within the genetic algorithm.
50+
# 'Generations' specifies the number of iterations in the genetic algorithm.
51+
#
52+
# GEQO runtime is roughly proportional to Pool_Size + Generations.
4753
#
4854
# 'Selection_Bias' gives us the selective pressure within the
4955
# population.
5056
#
5157
# 'Random_Seed' is the random seed for the random() function.
52-
# You don't have to set it.
58+
# You don't have to set it. If you do set it, then successive GEQO
59+
# runs will produce repeatable results, whereas if you don't set it
60+
# there will be some randomness in the results...
5361

5462
# All parameters will be computed within the GEQO module when they
5563
# are not set in the pg_geqo file.

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp