summaryrefslogtreecommitdiff
path: root/src/backend/nodes/print.c
Commit message (Collapse)AuthorAgeFilesLines
* Reimplement nodeMaterial to use a temporary BufFile (or even memory, if theTom Lane2000-06-181-7/+1
| | | | | | | | | | materialized tupleset is small enough) instead of a temporary relation. This was something I was thinking of doing anyway for performance, and Jan says he needs it for TOAST because he doesn't want to cope with toasting noname relations. With this change, the 'noname table' support in heap.c is dead code, and I have accordingly removed it. Also clean up 'noname' plan handling in planner --- nonames are either sort or materialize plans, and it seems less confusing to handle them separately under those names.
* Ye-old pgindent run. Same 4-space tabs.Bruce Momjian2000-04-121-3/+3
|
* New cost model for planning, incorporating a penalty for random pageTom Lane2000-02-151-6/+6
| | | | | | | | | | | | | | | | | | | | | | | | | accesses versus sequential accesses, a (very crude) estimate of the effects of caching on random page accesses, and cost to evaluate WHERE- clause expressions. Export critical parameters for this model as SET variables. Also, create SET variables for the planner's enable flags (enable_seqscan, enable_indexscan, etc) so that these can be controlled more conveniently than via PGOPTIONS. Planner now estimates both startup cost (cost before retrieving first tuple) and total cost of each path, so it can optimize queries with LIMIT on a reasonable basis by interpolating between these costs. Same facility is a win for EXISTS(...) subqueries and some other cases. Redesign pathkey representation to achieve a major speedup in planning (I saw as much as 5X on a 10-way join); also minor changes in planner to reduce memory consumption by recycling discarded Path nodes and not constructing unnecessary lists. Minor cleanups to display more-plausible costs in some cases in EXPLAIN output. Initdb forced by change in interface to index cost estimation functions.
* Carry column aliases from the parser frontend. Enables queries likeThomas G. Lockhart2000-02-151-4/+5
| | | | | | | SELECT a FROM t1 tx (a); Allow join syntax, including queries like SELECT * FROM t1 NATURAL JOIN t2; Update RTE structure to hold column aliases in an Attr structure.
* Add:Bruce Momjian2000-01-261-2/+3
| | | | | | * Portions Copyright (c) 1996-2000, PostgreSQL, Inc to all files copyright Regents of Berkeley. Man, that's a lot of files.
* Another round of planner/optimizer work. This is just restructuring andTom Lane2000-01-091-3/+3
| | | | | code cleanup; no major improvements yet. However, EXPLAIN does produce more intuitive outputs for nested loops with indexscans now...
* Tid access method feature from Hiroshi Inoue, Inoue@tpf.co.jpBruce Momjian1999-11-231-1/+4
|
* Major planner/optimizer revision: get rid of PathOrder node type,Tom Lane1999-08-161-4/+4
| | | | | | | | | store all ordering information in pathkeys lists (which are now lists of lists of PathKeyItem nodes, not just lists of lists of vars). This was a big win --- the code is smaller and IMHO more understandable than it was, even though it handles more cases. I believe the node changes will not force an initdb for anyone; planner nodes don't show up in stored rules.
* Move some system includes into c.h, and remove duplicates.Bruce Momjian1999-07-171-3/+1
|
* Final cleanup.Bruce Momjian1999-07-161-2/+2
|
* Remove unused #includes in *.c files.Bruce Momjian1999-07-151-8/+1
|
* pgindent run over code.Bruce Momjian1999-05-251-4/+6
|
* Change error messages to oids come out as %u and not %d. Change has noBruce Momjian1999-05-101-2/+2
| | | | real affect now.
* Remove Tee code, move to _deadcode.Bruce Momjian1999-03-231-4/+1
|
* fix compile problem.Bruce Momjian1999-02-221-2/+2
|
* pathkeys.c cleanup.Bruce Momjian1999-02-211-2/+2
|
* pathkeys fixesBruce Momjian1999-02-201-7/+15
|
* Change my-function-name-- to my_function_name, and optimizer renames.Bruce Momjian1999-02-131-7/+7
|
* Rename Path.keys to Path.pathkeys. Too many 'keys' used for other things.Bruce Momjian1999-02-101-5/+5
|
* Rename Temp to Noname for noname tables.Bruce Momjian1999-02-091-3/+3
|
* Another SELECT speedup: extract OIDs of column print functionsTom Lane1999-01-271-2/+2
| | | | | only once per SELECT, not once per tuple. 10% here, 10% there, pretty soon you're talking about real speedups ...
* OK, folks, here is the pgindent output.Bruce Momjian1998-09-011-6/+9
|
* Check for null pointer returned from get_opname().Thomas G. Lockhart1998-08-161-2/+2
|
* Fix explain for union and inheritance. Rename Append structureBruce Momjian1998-07-151-1/+18
| | | | members to be clearer. Fix cost computation for these.
* Remove un-needed braces around single statements.Bruce Momjian1998-06-151-15/+1
|
* Parser cleanup.Bruce Momjian1998-01-201-6/+2
| | | | Add lock to i386 asm.
* Cleanup of outnodes.Bruce Momjian1998-01-071-2/+2
|
* Remove Existential, and ifdef out generate_fjoin. Neither did anything.Bruce Momjian1997-12-181-4/+1
|
* Break parser functions into smaller files, group together.Bruce Momjian1997-11-251-3/+3
|
* Rename strNcpy to StrNCpy, and change third parameter.Bruce Momjian1997-10-251-4/+4
|
* Used modified version of indent that understands over 100 typedefs.Bruce Momjian1997-09-081-11/+11
|
* Another PGINDENT run that changes variable indenting and case label ↵Bruce Momjian1997-09-081-144/+144
| | | | indenting. Also static variable indenting.
* Massive commit to run PGINDENT on all *.c and *.h files.Bruce Momjian1997-09-071-272/+310
|
* Make functions static where possible, enclose unused functions in #ifdef ↵Bruce Momjian1997-08-191-2/+5
| | | | NOT_USED.
* Fix pgproc names over 15 chars in output. Add strNcpy() function. remove ↵Bruce Momjian1997-08-121-6/+4
| | | | some (void) casts that are unnecessary.
* Cleanup for NAMEDATALEN use.Bruce Momjian1997-08-031-3/+3
|
* All external function definitions now have prototypes that are checked.Bruce Momjian1996-11-101-1/+3
|
* Just a couple of small modsMarc G. Fournier1996-11-061-2/+4
|
* Postgres95 1.01 Distribution - Virgin SourcesPG95-1_01Marc G. Fournier1996-07-091-0/+377
View Lorry Controller Status