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

Commitc8b42a6

Browse files
committed
Update flow chart.
1 parent439a2af commitc8b42a6

File tree

6 files changed

+92
-100
lines changed

6 files changed

+92
-100
lines changed

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

Lines changed: 3 additions & 5 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.17 1998/07/18 04:22:29 momjian Exp $
10+
* $Header: /cvsroot/pgsql/src/backend/optimizer/path/allpaths.c,v 1.18 1998/08/04 00:42:07 momjian Exp $
1111
*
1212
*-------------------------------------------------------------------------
1313
*/
@@ -105,16 +105,15 @@ static void
105105
find_rel_paths(Query*root,List*rels)
106106
{
107107
List*temp;
108-
RelOptInfo*rel;
109108
List*lastpath;
110109

111110
foreach(temp,rels)
112111
{
113112
List*sequential_scan_list;
114113
List*rel_index_scan_list;
115114
List*or_index_scan_list;
115+
RelOptInfo*rel= (RelOptInfo*)lfirst(temp);
116116

117-
rel= (RelOptInfo*)lfirst(temp);
118117
sequential_scan_list=lcons(create_seqscan_path(rel),
119118
NIL);
120119

@@ -125,8 +124,7 @@ find_rel_paths(Query *root, List *rels)
125124
rel->clauseinfo,
126125
rel->joininfo);
127126

128-
or_index_scan_list=
129-
create_or_index_paths(root,rel,rel->clauseinfo);
127+
or_index_scan_list=create_or_index_paths(root,rel,rel->clauseinfo);
130128

131129
rel->pathlist=add_pathlist(rel,
132130
sequential_scan_list,

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

Lines changed: 2 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -8,7 +8,7 @@
88
*
99
*
1010
* IDENTIFICATION
11-
* $Header: /cvsroot/pgsql/src/backend/optimizer/path/indxpath.c,v 1.23 1998/08/03 05:49:19 momjian Exp $
11+
* $Header: /cvsroot/pgsql/src/backend/optimizer/path/indxpath.c,v 1.24 1998/08/04 00:42:08 momjian Exp $
1212
*
1313
*-------------------------------------------------------------------------
1414
*/
@@ -1291,8 +1291,7 @@ create_index_paths(Query *root,
12911291
if (!join||temp)
12921292
{/* restriction, ordering scan */
12931293
temp_path=create_index_path(root,rel,index,clausegroup,join);
1294-
temp_node=
1295-
lcons(temp_path,NIL);
1294+
temp_node=lcons(temp_path,NIL);
12961295
ip_list=nconc(ip_list,temp_node);
12971296
}
12981297
}

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

Lines changed: 2 additions & 3 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/Attic/mergeutils.c,v 1.5 1998/02/26 04:32:41 momjian Exp $
10+
* $Header: /cvsroot/pgsql/src/backend/optimizer/path/Attic/mergeutils.c,v 1.6 1998/08/04 00:42:09 momjian Exp $
1111
*
1212
*-------------------------------------------------------------------------
1313
*/
@@ -61,8 +61,7 @@ group_clauses_by_order(List *clauseinfo_list,
6161

6262
p_ordering.ordtype=MERGE_ORDER;
6363
p_ordering.ord.merge=merge_ordering;
64-
xmergeinfo=
65-
match_order_mergeinfo(&p_ordering,mergeinfo_list);
64+
xmergeinfo=match_order_mergeinfo(&p_ordering,mergeinfo_list);
6665
if (inner_relid==leftop->varno)
6766
{
6867
keys=makeNode(JoinKey);

‎src/tools/backend/flow.fig

Lines changed: 66 additions & 71 deletions
Original file line numberDiff line numberDiff line change
@@ -3,134 +3,129 @@ Landscape
33
Center
44
Inches
55
1200 2
6-
6 450 375 2250 1575
7-
4 0 -1 0 0 0 24 0.0000 4 255 735 450 1515 Flow\001
8-
4 0 -1 0 0 0 24 0.0000 4 330 1800 450 675 PostgreSQL\001
9-
4 0 -1 0 0 0 24 0.0000 4 330 1290 450 1095 Program\001
10-
-6
11-
2 1 0 1 -1 7 0 0 -1 0.000 0 0 -1 0 0 1
12-
8475 2175
13-
2 1 0 1 -1 7 0 0 -1 0.000 0 0 -1 0 0 1
14-
8475 2175
15-
2 4 0 1 -1 29 0 0 20 0.000 0 0 7 0 0 5
16-
2850 13200 450 13200 450 12600 2850 12600 2850 13200
176
2 1 0 2 29 7 0 0 -1 0.000 0 0 -1 1 1 2
187
0 0 2.00 150.00 180.00
198
0 0 2.00 150.00 180.00
20-
1650 12600 1650 12000
9+
7950 10200 7950 10800
10+
2 1 0 1 -1 7 0 0 -1 0.000 0 0 -1 0 0 1
11+
8400 375
12+
2 1 0 1 -1 7 0 0 -1 0.000 0 0 -1 0 0 1
13+
8400 375
2114
2 4 0 1 -1 29 0 0 20 0.000 0 0 7 0 0 5
22-
9225 13200 6825 13200 6825 12600 9225 12600 9225 13200
15+
2775 11400 375 11400 375 10800 2775 10800 2775 11400
2316
2 1 0 2 29 7 0 0 -1 0.000 0 0 -1 1 1 2
2417
0 0 2.00 150.00 180.00
2518
0 0 2.00 150.00 180.00
26-
8025 11925 8025 12525
19+
1575 10800 1575 10200
2720
2 4 0 1 -1 29 0 0 20 0.000 0 0 7 0 0 5
28-
6000 13200 3600 13200 3600 12600 6000 12600 6000 13200
21+
9150 11400 6750 11400 6750 10800 9150 10800 9150 11400
22+
2 4 0 1 -1 29 0 0 20 0.000 0 0 7 0 0 5
23+
5925 11400 3525 11400 3525 10800 5925 10800 5925 11400
2924
2 1 0 2 29 7 0 0 -1 0.000 0 0 -1 1 1 2
3025
0 0 2.00 150.00 180.00
3126
0 0 2.00 150.00 180.00
32-
4800 12600 4800 12000
27+
4725 10800 4725 10200
3328
2 4 0 1 -1 29 0 0 20 0.000 0 0 7 0 0 5
34-
4425 14400 2025 14400 2025 13800 4425 13800 4425 14400
29+
4350 12600 1950 12600 1950 12000 4350 12000 4350 12600
3530
2 1 0 2 29 7 0 0 -1 0.000 0 0 -1 1 1 2
3631
0 0 2.00 150.00 180.00
3732
0 0 2.00 150.00 180.00
38-
3225 13200 3225 13800
33+
3150 11400 3150 12000
3934
2 1 0 2 8 7 0 0 -1 0.000 0 0 -1 1 0 2
4035
0 0 2.00 150.00 180.00
41-
2625 6675 2625 7275
36+
2550 4875 2550 5475
4237
2 4 0 1 -1 4 0 0 20 0.000 0 0 7 0 0 5
43-
3825 3975 1425 3975 1425 3375 3825 3375 3825 3975
38+
3750 2175 1350 2175 1350 1575 3750 1575 3750 2175
4439
2 4 0 1 -1 8 0 0 20 0.000 0 0 7 0 0 5
45-
3825 6675 1425 6675 1425 6075 3825 6075 3825 6675
40+
3750 4875 1350 4875 1350 4275 3750 4275 3750 4875
4641
2 4 0 1 -1 8 0 0 20 0.000 0 0 7 0 0 5
47-
3825 9075 1425 9075 1425 8475 3825 8475 3825 9075
42+
3750 7275 1350 7275 1350 6675 3750 6675 3750 7275
4843
2 1 0 2 8 7 0 0 -1 0.000 0 0 -1 1 0 2
4944
0 0 2.00 150.00 180.00
50-
2625 7875 2625 8475
45+
2550 6075 2550 6675
5146
2 4 0 1 -1 8 0 0 20 0.000 0 0 7 0 0 5
52-
3825 10275 1425 10275 1425 9675 3825 9675 3825 10275
47+
3750 8475 1350 8475 1350 7875 3750 7875 3750 8475
5348
2 1 0 2 8 7 0 0 -1 0.000 0 0 -1 1 0 2
5449
0 0 2.00 150.00 180.00
55-
2625 9075 2625 9675
50+
2550 7275 2550 7875
5651
2 1 0 2 8 7 0 0 -1 0.000 0 0 -1 1 0 2
5752
0 0 2.00 150.00 180.00
58-
2625 10275 2625 10875
53+
2550 8475 2550 9075
5954
2 4 0 1 -1 8 0 0 20 0.000 0 0 7 0 0 5
60-
7725 7875 5325 7875 5325 7275 7725 7275 7725 7875
55+
7650 6075 5250 6075 5250 5475 7650 5475 7650 6075
6156
2 1 0 2 8 7 0 0 -1 0.000 0 0 -1 1 0 2
6257
0 0 2.00 150.00 180.00
63-
2625 5775 2625 6075
58+
2550 3975 2550 4275
6459
2 4 0 1 -1 8 0 0 20 0.000 0 0 7 0 0 5
65-
3825 11475 1425 11475 1425 10875 3825 10875 3825 11475
66-
2 1 0 2 31 7 0 0 -1 0.000 0 0 -1 1 0 2
67-
0 0 2.00 150.00 180.00
68-
2625 5175 2625 5775
60+
3750 9675 1350 9675 1350 9075 3750 9075 3750 9675
6961
2 4 0 1 -1 31 0 0 20 0.000 0 0 7 0 0 5
70-
3825 5175 1425 5175 1425 4575 3825 4575 3825 5175
62+
3750 3375 1350 3375 1350 2775 3750 2775 3750 3375
7163
2 4 0 1 -1 31 0 0 20 0.000 0 0 7 0 0 5
72-
7725 5175 5325 5175 5325 4575 7725 4575 7725 5175
64+
7650 3375 5250 3375 5250 2775 7650 2775 7650 3375
7365
2 4 0 1 -1 17 1 0 20 0.000 0 0 40 0 0 5
74-
8775 11775 375 11775 375 5625 8775 5625 8775 11775
66+
8700 9975 300 9975 300 3825 8700 3825 8700 9975
7567
2 4 0 1 -1 0 0 0 20 0.000 0 0 7 0 0 5
76-
7725 3375 5325 3375 5325 2775 7725 2775 7725 3375
68+
7650 1575 5250 1575 5250 975 7650 975 7650 1575
7769
2 4 0 1 -1 23 0 0 20 0.000 0 0 8 0 0 5
78-
2925 15675 525 15675 525 15075 2925 15075 2925 15675
70+
2850 13875 450 13875 450 13275 2850 13275 2850 13875
7971
2 1 0 2 25 7 0 0 -1 0.000 0 0 -1 1 0 2
8072
0 0 2.00 150.00 180.50
81-
2625 2775 2625 3375
73+
2550 975 2550 1575
8274
2 4 0 1 -1 26 0 0 20 0.000 0 0 7 0 0 5
83-
3825 2775 1425 2775 1425 2175 3825 2175 3825 2775
75+
3750 975 1350 975 1350 375 3750 375 3750 975
8476
2 1 0 2 20 7 0 0 -1 0.000 0 0 -1 1 0 2
8577
0 0 2.00 150.00 180.00
86-
2625 3975 2625 4575
78+
2550 2175 2550 2775
8779
2 1 0 2 20 7 0 0 -1 0.000 0 0 -1 1 0 2
8880
0 0 2.00 150.00 180.00
89-
2625 3975 6525 4575
81+
2550 2175 6450 2775
9082
2 1 1 2 -1 7 0 0 -1 4.000 0 0 -1 1 1 2
9183
0 0 2.00 150.00 180.00
9284
0 0 2.00 150.00 180.00
93-
4890 3708 5325 3150
85+
4815 1908 5250 1350
9486
2 4 0 1 -1 29 0 0 20 0.000 0 0 7 0 0 5
95-
7725 14400 5325 14400 5325 13800 7725 13800 7725 14400
87+
7650 12600 5250 12600 5250 12000 7650 12000 7650 12600
9688
2 1 0 2 29 7 0 0 -1 0.000 0 0 -1 1 1 2
9789
0 0 2.00 150.00 180.00
9890
0 0 2.00 150.00 180.00
99-
6450 13200 6450 13800
91+
6375 11400 6375 12000
10092
2 1 0 2 8 7 0 0 -1 0.000 0 0 -1 1 0 2
10193
0 0 2.00 150.00 180.00
102-
3825 7575 5325 7575
94+
3750 5775 5250 5775
10395
2 4 0 1 -1 8 0 0 20 0.000 0 0 7 0 0 5
104-
3825 7875 1425 7875 1425 7275 3825 7275 3825 7875
96+
3750 6075 1350 6075 1350 5475 3750 5475 3750 6075
10597
2 1 1 2 -1 7 0 0 -1 3.000 0 0 -1 1 1 2
10698
0 0 2.00 150.00 180.00
10799
0 0 2.00 150.00 180.00
108-
4735 3324 5370 3093
100+
4660 1524 5295 1293
101+
2 1 0 2 31 7 0 0 -1 0.000 0 0 -1 1 0 2
102+
0 0 2.00 150.00 180.00
103+
2550 3300 2550 3900
109104
3 0 0 2 8 7 0 0 -1 0.000 0 1 0 5
110105
0 0 2.00 150.00 180.00
111-
7725 7575 8325 7275 8325 6375 7800 5775 2625 5775
106+
7650 5775 8250 5475 8250 4575 7725 3975 2550 3975
112107
3 0 0 2 8 7 0 0 -1 0.000 0 1 0 5
113108
0 0 2.00 150.00 180.00
114-
1425 11175 825 10725 825 6225 1575 5775 2625 5775
115-
4 1 -1 0 0 28 18 0.0000 4 195 10501635 12990 Utilities\001
116-
4 1 -1 0 0 28 18 0.0000 4 240 23258040 12990 Storage Managers\001
117-
4 1 -1 0 0 0 18 0.0000 4 255 8404800 12975 Catalog\001
118-
4 1 -1 0 0 28 18 0.0000 4 195 21003210 14205 Access Methods\001
119-
4 1 7 0 0 28 18 0.0000 4 195 19802610 9030 Generate Paths\001
120-
4 1 7 0 0 28 18 0.0000 4 195 14856525 7830 Commands\001
121-
4 1 7 0 0 28 18 0.0000 4 195 18302640 10245 Generate Plan\001
122-
4 1 -1 0 0 28 18 0.0000 4 195 14702610 3765 Postmaster\001
123-
4 1 -1 0 0 28 18 0.0000 4 240 11106510 4950 Postgres\001
124-
4 1 -1 0 0 28 18 0.0000 4 240 11102625 4965 Postgres\001
125-
4 1 7 0 0 28 18 0.0000 4 195 12752640 8745 Rewrite &\001
126-
4 1 7 0 0 28 18 0.0000 4 255 15002640 7665 Traffic Cop\001
127-
4 1 7 0 0 28 18 0.0000 4 195 8252610 6450 Parser\001
128-
4 1 7 0 0 28 18 0.0000 4 195 18902625 9975 Choose Path &\001
129-
4 1 7 0 0 28 18 0.0000 4 195 11402610 11295 Executor\001
130-
4 1 8 0 0 28 18 0.0000 4 240 7954530 7500 utility\001
131-
4 1 7 0 0 28 18 0.0000 4 240 8256525 7545 Utility\001
132-
4 1 -1 0 0 28 18 0.0000 4 195 6302595 2565 Main\001
133-
4 1 8 0 0 28 18 0.0000 4 240 11252640 8235 complex\001
134-
4 1 -1 0 0 0 18 0.0000 4 225 14256525 14175 Nodes / Lists\001
135-
4 1 7 0 0 0 18 0.0000 4 255 6456525 3150 Libpq\001
136-
4 1 -1 0 0 0 18 0.0000 4 255 10951725 15450 Bootstrap\001
109+
1350 9375 750 8925 750 4425 1500 3975 2550 3975
110+
4 1 -1 0 0 28 18 0.0000 4 195 10501560 11190 Utilities\001
111+
4 1 -1 0 0 28 18 0.0000 4 240 23257965 11190 Storage Managers\001
112+
4 1 -1 0 0 0 18 0.0000 4 255 8404725 11175 Catalog\001
113+
4 1 -1 0 0 28 18 0.0000 4 195 21003135 12405 Access Methods\001
114+
4 1 7 0 0 28 18 0.0000 4 195 19802535 7230 Generate Paths\001
115+
4 1 7 0 0 28 18 0.0000 4 195 14856450 6030 Commands\001
116+
4 1 7 0 0 28 18 0.0000 4 195 18302565 8445 Generate Plan\001
117+
4 1 -1 0 0 28 18 0.0000 4 195 14702535 1965 Postmaster\001
118+
4 1 -1 0 0 28 18 0.0000 4 240 11106435 3150 Postgres\001
119+
4 1 -1 0 0 28 18 0.0000 4 240 11102550 3165 Postgres\001
120+
4 1 7 0 0 28 18 0.0000 4 195 12752565 6945 Rewrite &\001
121+
4 1 7 0 0 28 18 0.0000 4 255 15002565 5865 Traffic Cop\001
122+
4 1 7 0 0 28 18 0.0000 4 195 8252535 4650 Parser\001
123+
4 1 7 0 0 28 18 0.0000 4 195 18902550 8175 Choose Path &\001
124+
4 1 7 0 0 28 18 0.0000 4 195 11402535 9495 Executor\001
125+
4 1 8 0 0 28 18 0.0000 4 240 7954455 5700 utility\001
126+
4 1 7 0 0 28 18 0.0000 4 240 8256450 5745 Utility\001
127+
4 1 -1 0 0 28 18 0.0000 4 195 6302520 765 Main\001
128+
4 1 8 0 0 28 18 0.0000 4 240 11252565 6435 complex\001
129+
4 1 -1 0 0 0 18 0.0000 4 225 14256450 12375 Nodes / Lists\001
130+
4 1 7 0 0 0 18 0.0000 4 255 6456450 1350 Libpq\001
131+
4 1 -1 0 0 0 18 0.0000 4 255 10951650 13650 Bootstrap\001

‎src/tools/backend/flow.jpg

-3.93 KB
Loading

‎src/tools/backend/index.html

Lines changed: 19 additions & 18 deletions
Original file line numberDiff line numberDiff line change
@@ -13,32 +13,33 @@ <H2 ALIGN=CENTER>
1313
<CENTER>
1414
<BR>
1515
<BR>
16-
<IMGsrc="flow.jpg"usemap="#flowmap"alt="flowchart">
16+
<IMGsrc="flow.jpg"usemap="#flowmap"alt="flowchart"border=0>
1717
</CENTER>
1818
<MAPname="flowmap">
19-
<AREACOORDS="80,130,240,170"HREF="backend_dirs.html#main">
20-
<AREACOORDS="80,210,240,250"HREF="backend_dirs.html#postmaster">
21-
<AREACOORDS="340,170,500,210"HREF="backend_dirs.html#libpq">
22-
<AREACOORDS="80,290,240,330"HREF="backend_dirs.html#tcop">
23-
<AREACOORDS="340,290,500,330"HREF="backend_dirs.html#tcop">
24-
<AREACOORDS="80,390,240,430"HREF="backend_dirs.html#parser">
25-
<AREACOORDS="80,470,240,510"HREF="backend_dirs.html#tcop">
26-
<AREACOORDS="80,550,240,590"HREF="backend_dirs.html#optimizer">
27-
<AREACOORDS="80,530,240,670"HREF="backend_dirs.html#optimizer/plan">
28-
<AREACOORDS="80,710,240,750"HREF="backend_dirs.html#executor">
29-
<AREACOORDS="340,470,500,510"HREF="backend_dirs.html#commands">
30-
<AREACOORDS="10,820,170,870"HREF="backend_dirs.html#utils">
31-
<AREACOORDS="220,820,380,860"HREF="backend_dirs.html#catalog">
32-
<AREACOORDS="430,820,600,870"HREF="backend_dirs.html#storage">
33-
<AREACOORDS="110,900,280,950"HREF="backend_dirs.html#access">
34-
<AREACOORDS="340,900,500,950"HREF="backend_dirs.html#nodes">
35-
<AREACOORDS="20,990,180,1030"HREF="backend_dirs.html#bootstrap">
19+
<AREACOORDS="80,10,240,50"HREF="backend_dirs.html#main">
20+
<AREACOORDS="80,90,240,130"HREF="backend_dirs.html#postmaster">
21+
<AREACOORDS="340,50,500,90"HREF="backend_dirs.html#libpq">
22+
<AREACOORDS="80,170,240,210"HREF="backend_dirs.html#tcop">
23+
<AREACOORDS="340,170,500,210"HREF="backend_dirs.html#tcop">
24+
<AREACOORDS="80,270,240,310"HREF="backend_dirs.html#parser">
25+
<AREACOORDS="80,350,240,390"HREF="backend_dirs.html#tcop">
26+
<AREACOORDS="80,430,240,470"HREF="backend_dirs.html#optimizer">
27+
<AREACOORDS="80,410,240,550"HREF="backend_dirs.html#optimizer/plan">
28+
<AREACOORDS="80,590,240,630"HREF="backend_dirs.html#executor">
29+
<AREACOORDS="340,350,500,390"HREF="backend_dirs.html#commands">
30+
<AREACOORDS="10,700,170,750"HREF="backend_dirs.html#utils">
31+
<AREACOORDS="220,700,380,740"HREF="backend_dirs.html#catalog">
32+
<AREACOORDS="430,700,600,750"HREF="backend_dirs.html#storage">
33+
<AREACOORDS="110,780,280,830"HREF="backend_dirs.html#access">
34+
<AREACOORDS="340,780,500,830"HREF="backend_dirs.html#nodes">
35+
<AREACOORDS="20,870,180,910"HREF="backend_dirs.html#bootstrap">
3636
</MAP>
3737
<CENTER><EM>
3838
Click on an item to see more detail or look at the full
3939
<AHREF="backend_dirs.html">index.</A>
4040
</EM></CENTER>
4141
<BR>
42+
<BR>
4243

4344
<P>
4445

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp