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

Commit8bc7439

Browse files
committed
Enable GEQO for more than six tables, from Martin.
1 parent4d9b4dc commit8bc7439

File tree

2 files changed

+5
-3
lines changed

2 files changed

+5
-3
lines changed

‎src/backend/optimizer/path/allpaths.c

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -7,7 +7,7 @@
77
*
88
*
99
* IDENTIFICATION
10-
* $Header: /cvsroot/pgsql/src/backend/optimizer/path/allpaths.c,v 1.6 1997/04/29 04:37:22 vadim Exp $
10+
* $Header: /cvsroot/pgsql/src/backend/optimizer/path/allpaths.c,v 1.7 1997/06/01 02:55:44 momjian Exp $
1111
*
1212
*-------------------------------------------------------------------------
1313
*/
@@ -173,7 +173,7 @@ find_join_paths(Query *root, List *outer_rels, int levels_left)
173173
* <utesch@aut.tu-freiberg.de> *
174174
*******************************************/
175175

176-
if (_use_geqo_ )
176+
if ((_use_geqo_)||length(root->base_relation_list_) >=GEQO_RELS )
177177
returnlcons(geqo(root),NIL);/* returns *one* Rel, so lcons it */
178178

179179
/*******************************************

‎src/include/optimizer/geqo.h

Lines changed: 3 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -5,7 +5,7 @@
55
*
66
* Copyright (c) 1994, Regents of the University of California
77
*
8-
* $Id: geqo.h,v 1.1 1997/02/19 12:58:28 scrappy Exp $
8+
* $Id: geqo.h,v 1.2 1997/06/01 02:56:00 momjian Exp $
99
*
1010
*-------------------------------------------------------------------------
1111
*/
@@ -38,6 +38,8 @@
3838
*/
3939
#defineERX
4040

41+
/* GEQO switch according to number of relations in a query */
42+
#defineGEQO_RELS 7
4143

4244
/* genetic algorithm parameters */
4345

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp