Skip to content
Snippets Groups Projects
  1. Sep 18, 2009
  2. Jun 11, 2009
  3. Apr 06, 2009
  4. Jan 01, 2009
  5. Apr 14, 2008
    • Tom Lane's avatar
      Push index operator lossiness determination down to GIST/GIN opclass · 9b5c8d45
      Tom Lane authored
      "consistent" functions, and remove pg_amop.opreqcheck, as per recent
      discussion.  The main immediate benefit of this is that we no longer need
      8.3's ugly hack of requiring @@@ rather than @@ to test weight-using tsquery
      searches on GIN indexes.  In future it should be possible to optimize some
      other queries better than is done now, by detecting at runtime whether the
      index match is exact or not.
      
      Tom Lane, after an idea of Heikki's, and with some help from Teodor.
      9b5c8d45
  6. Jan 01, 2008
  7. Nov 15, 2007
  8. Sep 07, 2007
  9. Jan 05, 2007
  10. Oct 04, 2006
  11. Sep 10, 2006
    • Tom Lane's avatar
      Rename contains/contained-by operators to @> and <@, per discussion that · ba920e1c
      Tom Lane authored
      agreed these symbols are less easily confused.  I made new pg_operator
      entries (with new OIDs) for the old names, so as to provide backward
      compatibility while making it pretty easy to remove the old names in
      some future release cycle.  This commit only touches the core datatypes,
      contrib will be fixed separately.
      ba920e1c
  12. Jul 14, 2006
  13. Jun 28, 2006
    • Teodor Sigaev's avatar
      Changes · 1f7ef548
      Teodor Sigaev authored
      * new split algorithm (as proposed in http://archives.postgresql.org/pgsql-hackers/2006-06/msg00254.php)
        * possible call pickSplit() for second and below columns
        * add spl_(l|r)datum_exists to GIST_SPLITVEC -
          pickSplit should check its values to use already defined
          spl_(l|r)datum for splitting. pickSplit should set
          spl_(l|r)datum_exists to 'false' (if they was 'true') to
          signal to caller about using spl_(l|r)datum.
        * support for old pickSplit(): not very optimal
          but correct split
      * remove 'bytes' field from GISTENTRY: in any case size of
        value is defined by it's type.
      * split GIST_SPLITVEC to two structures: one for using in picksplit
        and second - for internal use.
      * some code refactoring
      * support of subsplit to rtree opclasses
      
      TODO: add support of subsplit to contrib modules
      1f7ef548
  14. Mar 05, 2006
  15. Nov 07, 2005
  16. Oct 15, 2005
  17. Sep 22, 2005
  18. Jul 01, 2005
  19. Jun 24, 2005
    • Tom Lane's avatar
      Extend r-tree operator classes to handle Y-direction tests equivalent · b90f8f20
      Tom Lane authored
      to the existing X-direction tests.  An rtree class now includes 4 actual
      2-D tests, 4 1-D X-direction tests, and 4 1-D Y-direction tests.
      This involved adding four new Y-direction test operators for each of
      box and polygon; I followed the PostGIS project's lead as to the names
      of these operators.
      NON BACKWARDS COMPATIBLE CHANGE: the poly_overleft (&<) and poly_overright
      (&>) operators now have semantics comparable to box_overleft and box_overright.
      This is necessary to make r-tree indexes work correctly on polygons.
      Also, I changed circle_left and circle_right to agree with box_left and
      box_right --- formerly they allowed the boundaries to touch.  This isn't
      actually essential given the lack of any r-tree opclass for circles, but
      it seems best to sync all the definitions while we are at it.
      b90f8f20
    • Tom Lane's avatar
      Fix rtree and contrib/rtree_gist search behavior for the 1-D box and · 9a09248e
      Tom Lane authored
      polygon operators (<<, &<, >>, &>).  Per ideas originally put forward
      by andrew@supernews and later rediscovered by moi.  This patch just
      fixes the existing opclasses, and does not add any new behavior as I
      proposed earlier; that can be sorted out later.  In principle this
      could be back-patched, since it changes only search behavior and not
      system catalog entries nor rtree index contents.  I'm not currently
      planning to do that, though, since I think it could use more testing.
      9a09248e
  20. May 25, 2005
  21. May 21, 2005
  22. Aug 29, 2004
  23. Mar 30, 2004
  24. Nov 29, 2003
    • PostgreSQL Daemon's avatar
      · 969685ad
      PostgreSQL Daemon authored
      $Header: -> $PostgreSQL Changes ...
      969685ad
  25. Jul 27, 2003
  26. Sep 04, 2002
  27. May 28, 2002
  28. Oct 25, 2001
  29. Oct 01, 2001
  30. Aug 22, 2001
  31. May 31, 2001
Loading