GiST support in PostgreSQL [Oleg Bartunov]
Oleg
[Teodor Sigaev]
Teodor
GiST home | Introduction | GiST interface (Russian) | Readings
Search PostgreSQL resources | OpenFTS | PostgreSQL site

Search PostgreSQL resources:www.pgsql.ru

Software:

Development history

May 26, 2006

Fixed small bug in GIN code. Patch to the current stable 8.1.X, which introduces Gin (Generalized Inverted Index) support. Also, the patch contains full utf-8 support, query rewriting and improved rank_cd function.

May 3, 2006

Fixed small bug in contrib/hstore module. Get new version hstore.tar.gz. Thanks hubert depesz lubaczewski for report.

Apr 8, 2006

Tsearch2 with full utf-8 support, query rewriting and improved rank_cd function is available. Read Tsearch2WhatsNew for details.

Jul 1, 2005

contrib/rtree_gist is moved to PostgreSQL core !

Jun 27, 2005

GiST is now concurrent !

full concurrency for insert/update/select/vacuum:
        - select and vacuum never locks more than one page simultaneously
        - select (gettuple) hasn't any lock across it's calls
        - insert never locks more than two page simultaneously:
                - during search of leaf to insert it locks only one page simultaneously
                - while walk upward to the root it locked only parent (maybe non-direct parent) and child. 
		   One of them X-lock, another may be S- or X-lock
- 'vacuum full' locks index
- improve gistgetmulti
- simplify XLOG records

Jun 15, 2005

Online backup and crush recovery are supported now for GiST extensions !

Jun 07, 2005

We began working on GiST concurrency and recovery for 8.1. More information is here. Support our work ! See posting in PostGIS mailing list about contribution.

Feb 21, 2005 Fixed memory leak in contrib/btree_gist ( timestamp*). Check REL8_0_STABLE branch in CVS.

Jan 27, 2005 Documented function intset(int4) in README.intarray

Jan 25, 2005 Several commits to CVS (8.1): tsearch2

Patch for 8.0 release which adds supports for query expansion expand_query_8.0.patch.gz . Please, test it !

Dec 28, 2004 New documentations about tsearch2 is available !

May 28, 2004 New patch to tsearch2 which adds support of words stat per document part is available from tsearch2 page. Example is available from Tsearch_V2_Notes

May 14, 2004

March 26, 2004

Experimental version of tsearch2 with ordering function (needed for some operations) is available for 7.3 and 7.4. Download it from tsearch2 page.

January 10, 2004

Janko Richter added support for timestamp with/without time zone, time with/without time zone, date, interval, oid, money and macaddr types to btree_gist.
Read README.btree_gist and download archive btree_gist-7.4.tar.gz for 7.4.

December 18, 2003

New version of tsearch2 for 7.3.X (and patch for 7.4) is available for downloading !
Changes:

December 10, 2003

New version of tsearch2 for 7.3.X (and patch for 7.4) is available for downloading !
Changes:

December 5, 2003

New version of tsearch2 for 7.3.X is available for downloading !
Changes:

December 4, 2003

New version of tsearch2 for 7.3.X is available for downloading !
Changes:

December 3, 2003

New version of tsearch2 for 7.3.X is available for downloading !
Changes:

November 28, 2003

New version of tsearch2 for 7.3.X (and patch for 7.4) is available for downloading !
Changes:

November 27, 2003

New version of tsearch2 for 7.3.X (and patch for 7.4) is available for downloading !
Changes:

Documentation for new feature will be added later.

October 10, 2003

New version of tsearch2 is available for downloading !
Changes:

September 22, 2003

New version of tsearch2 is available for downloading !
Changes:

August 28, 2003

New version of tsearch2 is available for downloading !
Changes:

August 13, 2003

New version of tsearch2 is available for downloading !
Changes:

August 6, 2003

New version of tsearch2 is available for downloading !
Changes:

July 21, 2003

Stable version of tsearch2 submitted to CVS !

July 18, 2003

New *development* version of tsearch V2 is available for download from Tsearch V2 home page.
Changes:
Documentation fixes (user and reference guide).

July 9, 2003

New *development* version of tsearch V2 is available for download from Tsearch V2 home page.
Changes:
Compatibility with 7.4-dev.

July 8, 2003

New *development* version of tsearch V2 is available for download from Tsearch V2 home page.
Changes:

July 7, 2003

New development version of tsearch V2 is available for download from Tsearch V2 home page.
Changes:

June 27, 2003

Buggy Day :)
tsearch-v2.1.6.tar.gz is available for download.
Changes:

June 27, 2003

tsearch-v2.1.5.tar.gz is available for download.
Changes:

June 27, 2003

tsearch-v2.1.4.tar.gz is available for download.
Changes:

June 26, 2003

tsearch-v2.1.3.tar.gz is available for download.
Changes:

June 23, 2003

tsearch-v2.1.2.tar.gz is available for download.
Changes:

June 21, 2003

Introduction to tsearch V2 by Andrew J. Kopciuch is available as tsearch-V2-intro.txt

June 19, 2003

New contrib module: Gendict - generate dictionary templates for contrib/tsearch v2 module. Download it from gendict.tar.gz, read README.gendict.

June 18, 2003

Road to release ! All features are frozen now ! Don't even try it.

New version of contrib/tsearch V2 is available for download (tsearch-v2.1.1.tar.gz).

Notice: This is an experimental version with new naming convention ! (see work in progress:http://rhodesmill.org/brandon/projects/tsearch-guide.html and http://rhodesmill.org/brandon/projects/tsearch-ref.html )

Changes:

May 19, 2003

New version of contrib/tsearch V2 is available for download (tsearch.tar.gz).
Changes:

May 14, 2003

New version of contrib/tsearch V2 is available for download (tsearch.tar.gz).
Changes:

May 8, 2003

Andrew J. Kopciuch wrote introductionary guide for beginners - tsearchV2-intro.txt Your comments and additions are welcome !

May 5, 2003

New version of contrib/tsearch V2 is available for download (tsearch.tar.gz).
Changes:

Apr 21, 2003

New version of contrib/tsearch V2 is available for download (tsearch.tar.gz).
Changes:

Mar 29, 2003

New version of contrib/tsearch V2 is available for download (tsearch.tar.gz).
Changes:

Mar 28, 2003

New version of contrib/tsearch V2 is available for download (tsearch.tar.gz).
Changes:

Patch for ltree ltree.732.patch.gz (patch for 7.4 is sumbitted to CVS).
Changes: Read ltree documentation for details.

Mar 20, 2003

New version of contrib/tsearch V2 is available for download (tsearch.tar.gz).
Fixed:

Mar 17, 2003

New version of contrib/tsearch V2 is available for download (tsearch.tar.gz).
Fixed:

Mar 11, 2003

btree_gist now supports int2, int8, float4, float8 ! Thanks Janko Richter for contribution.
Download sources btree_gist_new.tar.gz for 7.3 and above.

Feb 5, 2003

btree_gist now supports int8, float4, float8 ! Thanks Janko Richter for contribution.
Download sources btree_gist.tar.gz for 7.3 and above.

Tsearch New Generation is coming:
read README-V2.txt for details, download alpha-version tsearch.tar.gz for testing.

Dec 4

Fix for contrib/tsearch (postgresql 7.3) release is available tsearch_patch.gz. It's important for non-C or ru_RU.KOI8-R locales.
Thanks Magnus Naeslund(f). Patch was submitted to CVS.

Aug 9

Fixed very stupid but important bug in ltree. Download new version ltree-7.2.tar.gz for PostgreSQL 7.2. Patch for 7.3 submitted to CVS.

Aug 6

Reworked patch from Andrey Oktyabrski (ano@spider.ru) with functions: icount, sort, sort_asc, uniq, idx, subarray operations: #, +, -, |, &
Download patch.intarray and read README.intarray for additional info. Note: patch should work with 7.2 also.

Jul 31

Jul 13

Preliminary version of contrib/ltree module. Read documentation for details. Download ltree.tar.gz

Jun 14

All changes are committed to current CVS and 7.2 stable tree (7.2.2 release ?).

Jun 3 Patch for contrib/intarray (7.2.1)

May 27 Patch for contrib/rtree_gist (7.2.1)
May 26 Important patch for GiST (7.2.1)
Apr 24
Mar 19
Feb 12
Feb 7
Feb 6
Urgent !

Feb 5
Urgent !

Dec 5

Tue Oct 23

Fri Oct 12

Wed Aug 15

Tue Aug 7 23:43:18 MSD 2001

Tue Aug 4 23:43:18 MSD 2001

Thu Jun 28 15:40:52 MSD 2001

Tue Jun 5 19:06:05 MSD 2001

Jun 1 20:22:42 MSD 2001

Thu May 31 17:22:42 MSD 2001

Wed May 30 17:04:16 MSD 2001

Tue May 29 17:04:16 MSD 2001

Mon May 28 20:41:49 MSD 2001

Fri May 25 20:38:55 MSD 2001

Tue May 15 14:11:16 MSD 2001

Mon Mar 19 17:31:22 MSK 2001

Tue Jan 30 13:00:01 MSK 2001

Papers for reading:

Links:


All works was done by Teodor Sigaev (teodor@sigaev.ru) and Oleg Bartunov (oleg@sai.msu.su)
This work is partially supported by Russian Foundation for Basic Research
Last changes:Fri Jun 14 17:50:07 MSD 2002