1. 10 Nov, 2007 8 commits
  2. 09 Nov, 2007 10 commits
  3. 08 Nov, 2007 16 commits
  4. 07 Nov, 2007 6 commits
    • Tom Lane's avatar
      Improve the performance of LIKE/regex estimation in non-C locales, by making · 2de946be
      Tom Lane authored
      make_greater_string() try harder to generate a string that's actually greater
      than its input string.  Before we just assumed that making a string that was
      memcmp-greater was enough, but it is easy to generate examples where this is
      not so when the locale is not C.  Instead, loop until the relevant comparison
      function agrees that the generated string is greater than the input.
      
      Unfortunately this is probably not enough to guarantee that the generated
      string is greater than all extensions of the input, so we cannot relax the
      restriction to C locale for the LIKE/regex index optimization.  But it should
      at least improve the odds of getting a useful selectivity estimate in
      prefix_selectivity().  Per example from Guillaume Smet.
      
      Backpatch to 8.1, mainly because that's what the complainant is using...
      2de946be
    • Tom Lane's avatar
      Fix patternsel() and callers to do the right thing for NOT LIKE and the other · 95422871
      Tom Lane authored
      negated-match operators.  patternsel had been using the supplied operator as
      though it were a positive-match operator, and thus obtaining a wrong result,
      which was even more wrong after the caller subtracted it from 1.  Seems
      cleanest to give patternsel an explicit "negate" argument so that it knows
      what's going on.  Also install the same factorization scheme for pattern
      join selectivity estimators; even though they are just stubs at the
      moment, this may keep someone from making the same type of mistake when
      they get filled out.  Per report from Greg Mullane.
      
      Backpatch to 8.2 --- previous releases do not show the problem because
      patternsel() doesn't actually use the operator directly.
      95422871
    • Peter Eisentraut's avatar
    • Peter Eisentraut's avatar
      Consistent capitalization · 46c099ce
      Peter Eisentraut authored
      46c099ce
    • Peter Eisentraut's avatar
      Improve wording · e8c4f4e8
      Peter Eisentraut authored
      e8c4f4e8
    • Peter Eisentraut's avatar
      0e3c2753