1. 15 1月, 2000 1 次提交
  2. 11 1月, 2000 1 次提交
  3. 09 1月, 2000 1 次提交
  4. 25 11月, 1999 2 次提交
  5. 23 11月, 1999 1 次提交
  6. 19 9月, 1999 1 次提交
    • T
      Mega-commit to make heap_open/heap_openr/heap_close take an · bd272cac
      Tom Lane 提交于
      additional argument specifying the kind of lock to acquire/release (or
      'NoLock' to do no lock processing).  Ensure that all relations are locked
      with some appropriate lock level before being examined --- this ensures
      that relevant shared-inval messages have been processed and should prevent
      problems caused by concurrent VACUUM.  Fix several bugs having to do with
      mismatched increment/decrement of relation ref count and mismatched
      heap_open/close (which amounts to the same thing).  A bogus ref count on
      a relation doesn't matter much *unless* a SI Inval message happens to
      arrive at the wrong time, which is probably why we got away with this
      sloppiness for so long.  Repair missing grab of AccessExclusiveLock in
      DROP TABLE, ALTER/RENAME TABLE, etc, as noted by Hiroshi.
      Recommend 'make clean all' after pulling this update; I modified the
      Relation struct layout slightly.
      Will post further discussion to pghackers list shortly.
      bd272cac
  7. 09 9月, 1999 1 次提交
    • T
      Repair error noticed by Roberto Cornacchia: selectivity code · 51db6455
      Tom Lane 提交于
      was rejecting negative attnums as bogus, which of course they are not.
      Add code to get_attdisbursion to produce a useful value for OID attribute,
      since VACUUM does not store stats for system attributes.
      Also, repair bug that's been in eqjoinsel for a long time: it was taking
      the max of the two columns' disbursions, whereas it should use the min.
      51db6455
  8. 21 8月, 1999 1 次提交
  9. 09 8月, 1999 1 次提交
  10. 02 8月, 1999 1 次提交
    • T
      Further selectivity-estimation work. Speed up eqsel() · 8624ff76
      Tom Lane 提交于
      (it should just call the given operator, not look up an = operator).
      Fix intltsel() so that all numeric data types are converted to double
      before trying to estimate where the given comparison value is in the
      known range of column values.  intltsel() still needs work, or replacement,
      for non-numeric data types ... but for nonintegral numeric types it
      should now be delivering reasonable estimates.
      8624ff76
  11. 01 8月, 1999 1 次提交
    • T
      First step in fixing selectivity-estimation code. eqsel and · 44878506
      Tom Lane 提交于
      neqsel now behave as per my suggestions in pghackers a few days ago.
      selectivity for < > <= >= should work OK for integral types as well, but
      still need work for nonintegral types.  Since these routines have never
      actually executed before :-(, this may result in some significant changes
      in the optimizer's choices of execution plans.  Let me know if you see
      any serious misbehavior.
      CAUTION: THESE CHANGES REQUIRE INITDB.  pg_statistic table has changed.
      44878506
  12. 18 7月, 1999 1 次提交
  13. 16 7月, 1999 3 次提交
  14. 15 7月, 1999 1 次提交
  15. 19 6月, 1999 1 次提交
  16. 01 6月, 1999 1 次提交
  17. 26 5月, 1999 1 次提交
  18. 10 5月, 1999 1 次提交
  19. 19 3月, 1999 1 次提交
  20. 14 2月, 1999 1 次提交
  21. 06 2月, 1999 1 次提交
  22. 01 9月, 1998 2 次提交
  23. 19 8月, 1998 1 次提交
    • B
      heap_fetch requires buffer pointer, must be released; heap_getnext · 79715390
      Bruce Momjian 提交于
      no longer returns buffer pointer, can be gotten from scan;
      	descriptor; bootstrap can create multi-key indexes;
      pg_procname index now is multi-key index; oidint2, oidint4, oidname
      are gone (must be removed from regression tests); use System Cache
      rather than sequential scan in many places; heap_modifytuple no
      longer takes buffer parameter; remove unused buffer parameter in
      a few other functions; oid8 is not index-able; remove some use of
      single-character variable names; cleanup Buffer variables usage
      and scan descriptor looping; cleaned up allocation and freeing of
      tuples; 18k lines of diff;
      79715390
  24. 28 7月, 1998 1 次提交
  25. 16 6月, 1998 1 次提交
  26. 26 2月, 1998 1 次提交
  27. 12 2月, 1998 1 次提交
  28. 06 2月, 1998 1 次提交
  29. 31 1月, 1998 1 次提交
  30. 06 1月, 1998 1 次提交
  31. 05 1月, 1998 1 次提交
  32. 24 11月, 1997 1 次提交
  33. 21 11月, 1997 1 次提交
  34. 08 9月, 1997 1 次提交
  35. 07 9月, 1997 1 次提交
  36. 21 8月, 1997 1 次提交