File tree Expand file tree Collapse file tree 4 files changed +16
-14
lines changed
Expand file tree Collapse file tree 4 files changed +16
-14
lines changed Original file line number Diff line number Diff line change 1010 alink ="#0000ff ">
1111 < H1 > Frequently Asked Questions (FAQ) for PostgreSQL</ H1 >
1212
13- < P > Last updated: Tue Apr 8 20:43:08 EDT 2008</ P >
13+ < P > Last updated: Mon Mar 3 11:22:50 EST 2008</ P >
1414
1515 < P > Current maintainer: Bruce Momjian (< A href =
1616 "mailto:bruce@momjian.us "> bruce@momjian.us</ A > )
@@ -150,8 +150,10 @@ <H3 id="item1.1">1.1) What is PostgreSQL? How is it pronounced? What is Postgres
150150 http://www.postgresql.org/docs/faqs.FAQ_DEV.html</ A >
151151 </ P >
152152
153- < P > Postgres is a widely-used nickname for PostgreSQL. If you find
154- 'PostgreSQL' hard to pronounce, call it 'Postgres' instead.</ P >
153+ < P > Postgres is a widely-used nickname for PostgreSQL. It was the
154+ original name of the project at Berkeley and is strongly preferred
155+ over other nicknames. If you find 'PostgreSQL' hard to pronounce, call
156+ it 'Postgres' instead.</ P >
155157
156158 < H3 id ="item1.2 "> 1.2) Who controls PostgreSQL?< BR > </ H3 >
157159
Original file line number Diff line number Diff line change 1- $PostgreSQL: pgsql/src/backend/optimizer/README,v 1.43 2008/03/21 13:23:28 momjian Exp $
1+ $PostgreSQL: pgsql/src/backend/optimizer/README,v 1.44 2008/04/09 00:55:30 momjian Exp $
22
33Optimizer
44=========
@@ -73,8 +73,8 @@ tree is found by a recursive process:
7373
74741) Take each base relation in the query, and make a RelOptInfo structure
7575for it. Find each potentially useful way of accessing the relation,
76- including sequential and index scans, and make a Path representing that
77- way . All the Paths made for a given relation are placed in its
76+ including sequential and index scans, and make Paths representing those
77+ ways . All the Paths made for a given relation are placed in its
7878RelOptInfo.pathlist. (Actually, we discard Paths that are obviously
7979inferior alternatives before they ever get into the pathlist --- what
8080ends up in the pathlist is the cheapest way of generating each potentially
@@ -271,7 +271,7 @@ The primary entry point is planner().
271271
272272planner()
273273 set up for recursive handling of subqueries
274- do final cleanup after planning.
274+ do final cleanup after planning
275275-subquery_planner()
276276 pull up subqueries from rangetable, if possible
277277 canonicalize qual
Original file line number Diff line number Diff line change 1- $PostgreSQL: pgsql/src/backend/parser/README,v 1.7 2008/03/21 13:23:28 momjian Exp $
1+ $PostgreSQL: pgsql/src/backend/parser/README,v 1.8 2008/04/09 00:55:30 momjian Exp $
22
33Parser
44======
@@ -14,13 +14,13 @@ keywords.c turn keywords into specific tokens
1414gram.y parse the tokens and fill query-type-specific structures
1515analyze.c top level of parse analysis for optimizable queries
1616parse_clause.c handle clauses like WHERE, ORDER BY, GROUP BY, ...
17- parse_coerce.c handle coercing expressions to different types
17+ parse_coerce.c handle coercing expressions to different data types
1818parse_expr.c handle expressions like col, col + 3, x = 3 or x = 4
1919parse_oper.c handle operators in expressions
2020parse_agg.c handle aggregates, like SUM(col1), AVG(col2), ...
2121parse_func.c handle functions, table.column and column identifiers
2222parse_node.c create nodes for various structures
2323parse_target.c handle the result list of the query
2424parse_relation.c support routines for tables and column handling
25- parse_type.c support routines for type handling
25+ parse_type.c support routines for data type handling
2626parse_utilcmd.c parse analysis for utility commands (done at execution time)
Original file line number Diff line number Diff line change 1- $PostgreSQL: pgsql/src/backend/utils/mmgr/README,v 1.12 2008/03/20 17 :55:15 momjian Exp $
1+ $PostgreSQL: pgsql/src/backend/utils/mmgr/README,v 1.13 2008/04/09 00 :55:30 momjian Exp $
22
33Notes About Memory Allocation Redesign
44======================================
55
66Up through version 7.0, Postgres had serious problems with memory leakage
77during large queries that process a lot of pass-by-reference data. There
8- was no provision for recycling memory until end of query. This needs to be
9- fixed, even more so with the advent of TOAST which will allow very large
8+ was no provision for recycling memory until end of query. This needed to be
9+ fixed, even more so with the advent of TOAST which will allowed very large
1010chunks of data to be passed around in the system. This document describes
11- the new memory management plan implemented in 7.1.
11+ the new memory management system implemented in 7.1.
1212
1313
1414Background
You can’t perform that action at this time.
0 commit comments