1. 06 Aug, 1999 3 commits
    • 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 2 commits