- 15 12月, 2000 1 次提交
-
-
由 Tom Lane 提交于
comparison does not consider paths different when they differ only in uninteresting aspects of sort order. (We had a special case of this consideration for indexscans already, but generalize it to apply to ordered join paths too.) Be stricter about what is a canonical pathkey to allow faster pathkey comparison. Cache canonical pathkeys and dispersion stats for left and right sides of a RestrictInfo's clause, to avoid repeated computation. Total speedup will depend on number of tables in a query, but I see about 4x speedup of planning phase for a sample seven-table query.
-
- 14 12月, 2000 3 次提交
-
-
由 Hiroshi Inoue 提交于
-
由 Tom Lane 提交于
OIDs rather than names. Aside from being simpler and faster, this way doesn't blow up in the face of 'create temp table foo () inherits (foo)'. Which is a rather odd thing to do, but it seems some people want to.
-
由 Tom Lane 提交于
output first outer tuple before advancing...
-
- 13 12月, 2000 5 次提交
-
-
由 Bruce Momjian 提交于
Index: TODO =================================================================== RCS file: /home/projects/pgsql/cvsroot/pgsql/doc/TODO,v retrieving revision 1.300 diff -r1.300 TODO 3c3 < Last updated: Tue Dec 12 23:01:04 EST 2000 --- > Last updated: Tue Dec 12 23:01:53 EST 2000 21d20 < * test to show diffs for TODO changes
-
由 Bruce Momjian 提交于
Index: TODO =================================================================== RCS file: /home/projects/pgsql/cvsroot/pgsql/doc/TODO,v retrieving revision 1.299 diff -r1.299 TODO 3c3 < Last updated: Tue Dec 12 15:27:50 EST 2000 --- > Last updated: Tue Dec 12 23:01:04 EST 2000 20a21 > * test to show diffs for TODO changes
-
由 Tom Lane 提交于
avoid repeated evaluations in cost_qual_eval(). This turns out to save a useful fraction of planning time. No change to external representation of RestrictInfo --- although that node type doesn't appear in stored rules anyway.
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
the first paragraph: As an example, say we wish to find all the records that are in the temperature range of other records. In effect, we need to compare the temp_lo and temp_hi attributes of each EMP instance to the temp_lo and temp_hi attributes of all other EMP instances. I believe that EMP should read WEATHER, as the example query that follows joins WEATHER to itself. EMP is often used in Oracle examples. Regards, Graham Other RULE cleanups
-
- 12 12月, 2000 12 次提交
-
-
由 Tom Lane 提交于
ISO-compliant UNION/INTERSECT/EXCEPT. Revise discussion of rule rewriter to reflect new subselect-in-FROM implementation of views. Miscellaneous other cleanups.
-
由 Tom Lane 提交于
-
由 Tom Lane 提交于
-
由 Tom Lane 提交于
-
由 Vadim B. Mikheev 提交于
-
由 Bruce Momjian 提交于
-
由 Tom Lane 提交于
-
由 Bruce Momjian 提交于
not match.
-
由 Bruce Momjian 提交于
-
由 Vadim B. Mikheev 提交于
-
由 Tom Lane 提交于
-
由 Tom Lane 提交于
-
- 11 12月, 2000 12 次提交
-
-
由 Hiroshi Inoue 提交于
-
由 Hiroshi Inoue 提交于
-
由 Tatsuo Ishii 提交于
-
由 Bruce Momjian 提交于
-
由 Tom Lane 提交于
-
由 Bruce Momjian 提交于
all forms of foreign keys be exposed to SQLForeignKeys. This patch is in addition to the ones I mailed yesterday (forget had I changed that as well....) Michael Fork - CCNA - MCP - A+ Network Support - Toledo Internet Access - Toledo Ohio
-
由 Bruce Momjian 提交于
return foreign key information based on the pg_trigger system table. I have tested the patch with (what I believe) is all possible primary/foreign key combinations -- however I may have missed some, so if anyone feels like taking the patch for a test drive, here are some useful links: Michael Fork
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
line 1324: "left-hand" should be "right-hand" BTW: new document looks very good! And the new configure/build process seems much better then before! Thanks! Laser
-
由 Bruce Momjian 提交于
-
由 Peter Eisentraut 提交于
-
由 Bruce Momjian 提交于
-
- 10 12月, 2000 4 次提交
-
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
-
由 Tom Lane 提交于
is the only diff not accounted for by fmgr rewrite...
-
由 Tom Lane 提交于
-
- 09 12月, 2000 3 次提交
-
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
-