1. 01 3月, 1999 1 次提交
    • T
      Executor no longer cares about mergejoinop, mergerightorder, mergeleftorder, · b204d10c
      Tom Lane 提交于
      so remove them from MergeJoin node.  Hack together a partial
      solution for commuted mergejoin operators --- yesterday
      a mergejoin int4 = int8 would crash if the planner decided to
      commute it, today it works.  The planner's representation of
      mergejoins really needs a rewrite though.
      Also, further testing of mergejoin ops in opr_sanity regress test.
      b204d10c
  2. 18 2月, 1999 1 次提交
  3. 15 2月, 1999 1 次提交
  4. 14 2月, 1999 1 次提交
  5. 04 2月, 1999 1 次提交
  6. 24 1月, 1999 1 次提交
  7. 04 12月, 1998 1 次提交
  8. 28 11月, 1998 1 次提交
  9. 01 9月, 1998 2 次提交
  10. 31 8月, 1998 2 次提交
  11. 10 8月, 1998 1 次提交
  12. 09 8月, 1998 1 次提交
  13. 07 8月, 1998 1 次提交
  14. 16 6月, 1998 1 次提交
  15. 26 2月, 1998 1 次提交
  16. 13 2月, 1998 1 次提交
  17. 21 1月, 1998 1 次提交
  18. 22 12月, 1997 1 次提交
  19. 25 9月, 1997 1 次提交
  20. 09 9月, 1997 2 次提交
  21. 08 9月, 1997 1 次提交
  22. 07 9月, 1997 1 次提交
  23. 20 8月, 1997 1 次提交
  24. 22 1月, 1997 1 次提交
  25. 01 12月, 1996 1 次提交
  26. 06 11月, 1996 1 次提交
  27. 10 9月, 1996 1 次提交
    • M
      Fixes: · 796f7899
      Marc G. Fournier 提交于
      The problem is that the function arguments are not considered as possible key
      candidates for index scan and so only a sequential scan is possible inside
      the body of a function.  I have therefore made some patches to the optimizer
      so that indices are now used also by functions.  I have also moved the plan
      debug message from pg_eval to pg_plan so that it is printed also for plans
      genereated for function execution.  I had also to add an index rescan to the
      executor because it ignored the parameters set in the execution state, they
      were flagged as runtime variables in ExecInitIndexScan but then never used
      by the executor so that the scan were always done with any key=1. Very odd.
      This means that an index rescan is now done twice for each function execution
      which uses an index, the first time when the index scan is initialized and
      the second when the actual function arguments are finally available for the
      execution.  I don't know what is the cost of an double index scan but I
      suppose it is anyway less than the cost of a full sequential scan, at leat
      for large tables. This is my patch, you must also add -DINDEXSCAN_PATCH in
      Makefile.global to enable the changes.
      
      Submitted by: Massimo Dal Zotto <dz@cs.unitn.it>
      796f7899
  28. 26 7月, 1996 1 次提交
  29. 09 7月, 1996 1 次提交