Skip to content
Snippets Groups Projects
  1. Feb 26, 2002
  2. Jan 07, 2002
  3. Dec 29, 2001
  4. Dec 08, 2001
  5. Sep 03, 2001
  6. Mar 05, 2001
  7. Oct 05, 2000
  8. Sep 12, 2000
  9. Aug 29, 2000
  10. Aug 07, 2000
  11. Jul 14, 2000
  12. Jun 18, 2000
  13. Jun 09, 2000
  14. May 18, 2000
  15. Apr 18, 2000
  16. Apr 15, 2000
  17. Apr 14, 2000
  18. Apr 11, 2000
  19. Apr 09, 2000
  20. Apr 07, 2000
  21. Mar 31, 2000
  22. Mar 26, 2000
  23. Mar 17, 2000
  24. Feb 27, 2000
  25. Feb 19, 2000
  26. Feb 15, 2000
    • Tom Lane's avatar
      New cost model for planning, incorporating a penalty for random page · b1577a7c
      Tom Lane authored
      accesses versus sequential accesses, a (very crude) estimate of the
      effects of caching on random page accesses, and cost to evaluate WHERE-
      clause expressions.  Export critical parameters for this model as SET
      variables.  Also, create SET variables for the planner's enable flags
      (enable_seqscan, enable_indexscan, etc) so that these can be controlled
      more conveniently than via PGOPTIONS.
      
      Planner now estimates both startup cost (cost before retrieving
      first tuple) and total cost of each path, so it can optimize queries
      with LIMIT on a reasonable basis by interpolating between these costs.
      Same facility is a win for EXISTS(...) subqueries and some other cases.
      
      Redesign pathkey representation to achieve a major speedup in planning
      (I saw as much as 5X on a 10-way join); also minor changes in planner
      to reduce memory consumption by recycling discarded Path nodes and
      not constructing unnecessary lists.
      
      Minor cleanups to display more-plausible costs in some cases in
      EXPLAIN output.
      
      Initdb forced by change in interface to index cost estimation
      functions.
      b1577a7c
  27. Jul 22, 1999
  28. Jul 15, 1999
  29. Jul 14, 1999
  30. Jul 06, 1999
  31. Jun 17, 1999
  32. Jun 14, 1999
  33. Jun 09, 1999
  34. Jun 08, 1999
  35. Jun 04, 1999
Loading