minor improvement to contrib/fulltextindex docs 
Author Message
 minor improvement to contrib/fulltextindex docs

--=-542g15SEO+ZhU8/hAuBp
Content-Type: text/plain
Content-Transfer-Encoding: 7bit

This patch fixes an incorrect statement and makes a few cleanups to
contrib/fulltextindex/README.fti

Cheers,

Neil

--=-542g15SEO+ZhU8/hAuBp
Content-Disposition: attachment; filename=fti-docs-1.patch
Content-Type: text/x-patch; name=fti-docs-1.patch; charset=ANSI_X3.4-1968
Content-Transfer-Encoding: 7bit

Index: contrib/fulltextindex/README.fti
===================================================================
RCS file: /var/lib/cvs/pgsql-server/contrib/fulltextindex/README.fti,v
retrieving revision 1.5
diff -c -r1.5 README.fti
*** contrib/fulltextindex/README.fti    2 Sep 2002 06:27:04 -0000       1.5
--- contrib/fulltextindex/README.fti    15 Jan 2003 02:43:27 -0000
***************
*** 13,23 ****

  But this does not use any indices, and therefore, if your database
  gets very large, it will not have very high performance (the above query
! requires at least one sequential scan, it probably takes 2 due to the
! self-join).

  The approach used by this add-on is to define a trigger on the table and
! columns you want to do this queries on. On every insert in the table, it
  takes the value in the specified columns, breaks the text in these columns
  up into pieces, and stores all sub-strings into another table, together
  with a reference to the row in the original table that contained this
--- 13,22 ----

  But this does not use any indices, and therefore, if your database
  gets very large, it will not have very high performance (the above query
! requires a sequential scan of the table).

  The approach used by this add-on is to define a trigger on the table and
! columns you want to do these queries on. On every insert to the table, it
  takes the value in the specified columns, breaks the text in these columns
  up into pieces, and stores all sub-strings into another table, together
  with a reference to the row in the original table that contained this
***************
*** 27,33 ****
  substrings that occur in the original table. By making a join between
  the fti-table and the orig-table, we can get the actual rows we want
  (this can also be done by using subselects - but subselects are currently
! inefficient in Postgres, and maybe there're other ways too).

  The trigger code also allows an array called StopWords, that prevents
  certain words from being indexed.
--- 26,32 ----
  substrings that occur in the original table. By making a join between
  the fti-table and the orig-table, we can get the actual rows we want
  (this can also be done by using subselects - but subselects are currently
! inefficient in PostgreSQL, and maybe there're other ways too).

  The trigger code also allows an array called StopWords, that prevents
  certain words from being indexed.

--=-542g15SEO+ZhU8/hAuBp
Content-Type: text/plain
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
MIME-Version: 1.0

---------------------------(end of broadcast)---------------------------

--=-542g15SEO+ZhU8/hAuBp--



Sun, 03 Jul 2005 10:44:53 GMT
 minor improvement to contrib/fulltextindex docs

Patch applied and backpatched to 7.3.X.  Thanks.

---------------------------------------------------------------------------

Quote:

> This patch fixes an incorrect statement and makes a few cleanups to
> contrib/fulltextindex/README.fti

> Cheers,

> Neil

[ Attachment, skipping... ]

Quote:

> ---------------------------(end of broadcast)---------------------------


--
  Bruce Momjian                        |  http://candle.pha.pa.us

  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate

message can get through to the mailing list cleanly



Mon, 04 Jul 2005 01:14:49 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. minor doc improvements

2. minor PL/PgSQL doc improvement

3. minor doc improvements

4. minor doc improvements

5. pgsql/contrib/fulltextindex fti.pl

6. pgsql/contrib/fulltextindex README.fti fti.c f ...

7. Patch to contrib/fulltextindex/fti.sql

8. pgsql/contrib/fulltextindex (README.fti fti.c fti.pl fti.sql.in)

9. Trouble debugging contrib/fulltextindex

10. Changes in /contrib/fulltextindex

11. pgsql/contrib/fulltextindex fti.c

12. pgsql/contrib/fulltextindex (TODO)


 
Powered by phpBB® Forum Software