1. 07 Jan, 2002 1 commit
  2. 21 Nov, 2001 1 commit
  3. 26 Oct, 2001 1 commit
  4. 13 Sep, 2001 1 commit
  5. 10 Sep, 2001 1 commit
  6. 07 May, 2001 1 commit
    • Tom Lane's avatar
      Rewrite of planner statistics-gathering code. ANALYZE is now available as · f905d65e
      Tom Lane authored
      a separate statement (though it can still be invoked as part of VACUUM, too).
      pg_statistic redesigned to be more flexible about what statistics are
      stored.  ANALYZE now collects a list of several of the most common values,
      not just one, plus a histogram (not just the min and max values).  Random
      sampling is used to make the process reasonably fast even on very large
      tables.  The number of values and histogram bins collected is now
      user-settable via an ALTER TABLE command.
      
      There is more still to do; the new stats are not being used everywhere
      they could be in the planner.  But the remaining changes for this project
      should be localized, and the behavior is already better than before.
      
      A not-very-related change is that sorting now makes use of btree comparison
      routines if it can find one, rather than invoking '<' twice.
      f905d65e
  7. 29 Sep, 2000 1 commit
  8. 16 Apr, 2000 1 commit
    • Tom Lane's avatar
      Add new selectivity estimation functions for pattern-matching operators · 82849df6
      Tom Lane authored
      (LIKE and regexp matches).  These are not yet referenced in pg_operator,
      so by default the system will continue to use eqsel/neqsel.
      Also, tweak convert_to_scalar() logic so that common prefixes of strings
      are stripped off, allowing better accuracy when all strings in a table
      share a common prefix.
      82849df6
  9. 31 Mar, 2000 1 commit
  10. 17 Feb, 2000 1 commit
    • Tom Lane's avatar
      Finish repairing 6.5's problems with r-tree indexes: create appropriate · 598ea2c3
      Tom Lane authored
      selectivity functions and make the r-tree operators use them.  The
      estimation functions themselves are just stubs, unfortunately, but
      perhaps someday someone will make them compute realistic estimates.
      Change pg_am so that the optimizer can reliably tell the difference
      between ordered and unordered indexes --- before it would think that
      an r-tree index can be scanned in '<<' order, which is not right AFAIK.
      Repair broken negator links for network_sup and related ops.
      Initdb forced.  This might be my last initdb force for 7.0 ... hope so
      anyway ...
      598ea2c3
  11. 24 Jan, 2000 1 commit
    • Tom Lane's avatar
      First cut at making useful selectivity estimates for range queries · 0dbffa70
      Tom Lane authored
      (ie, WHERE x > lowbound AND x < highbound).  It's not very bright yet
      but it does something useful.  Also, rename intltsel/intgtsel to
      scalarltsel/scalargtsel to reflect usage better.  Extend convert_to_scalar
      to do something a little bit useful with string data types.  Still need
      to make it do something with date/time datatypes, but I'll wait for
      Thomas's datetime unification dust to settle first.  Eventually the
      routine ought not have any type-specific knowledge at all; it ought to
      be calling a type-dependent routine found via a pg_type column; but
      that's a task for another day.
      0dbffa70
  12. 26 May, 1999 1 commit
  13. 22 May, 1999 1 commit
  14. 21 May, 1999 1 commit
  15. 08 Apr, 1999 1 commit
  16. 29 Jul, 1998 1 commit
  17. 01 Mar, 1998 1 commit
  18. 15 Jan, 1997 1 commit