1. 06 Aug, 1999 4 commits
    • Thomas G. Lockhart's avatar
      Fix cross-reference markup so that only the *title* of the Operators · 6b075277
      Thomas G. Lockhart authored
       chapter is included, not the chapter itself.
      Thanks to Evelyn Mitchell <efm@tummy.com> for pointing it out.
      6b075277
    • Thomas G. Lockhart's avatar
      Remove explicit references to ref/ path in file names; use vpath instead. · 777a4f71
      Thomas G. Lockhart authored
      Fix rules for man pages to ensure double-pass to get cross references.
      Add a few new man pages.
      777a4f71
    • Thomas G. Lockhart's avatar
      Try to clarify characteristics of the SERIAL type. · 4f1766f1
      Thomas G. Lockhart authored
      Fix source indenting, which does not affect output.
      Note: still need docs on NUMERIC and DECIMAL
       (and let's not talk about regression tests :()
      4f1766f1
    • Tom Lane's avatar
      Revise generation of hashjoin paths: generate one path per · e1fad50a
      Tom Lane authored
      hashjoinable clause, not one path for a randomly-chosen element of each
      set of clauses with the same join operator.  That is, if you wrote
         SELECT ... WHERE t1.f1 = t2.f2 and t1.f3 = t2.f4,
      and both '=' ops were the same opcode (say, all four fields are int4),
      then the system would either consider hashing on f1=f2 or on f3=f4,
      but it would *not* consider both possibilities.  Boo hiss.
      Also, revise estimation of hashjoin costs to include a penalty when the
      inner join var has a high disbursion --- ie, the most common value is
      pretty common.  This tends to lead to badly skewed hash bucket occupancy
      and way more comparisons than you'd expect on average.
      I imagine that the cost calculation still needs tweaking, but at least
      it generates a more reasonable plan than before on George Young's example.
      e1fad50a
  2. 05 Aug, 1999 3 commits
  3. 03 Aug, 1999 1 commit
  4. 02 Aug, 1999 5 commits
  5. 01 Aug, 1999 5 commits
  6. 31 Jul, 1999 3 commits
  7. 30 Jul, 1999 11 commits
  8. 29 Jul, 1999 3 commits
  9. 28 Jul, 1999 4 commits
  10. 27 Jul, 1999 1 commit
    • Tom Lane's avatar
      Correct bug in best_innerjoin(): it should check all the · b62fdc13
      Tom Lane authored
      rels that the inner path needs to join to, but it was only checking for
      the first one.  Failure could only have been observed with an OR-clause
      that mentions 3 or more tables, and then only if the bogus path was
      actually selected as cheapest ...
      b62fdc13