Skip site navigation (1) Skip section navigation (2)

Re: Updated tsearch documentation

From: Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Cc: Bruce Momjian <bruce(at)momjian(dot)us>, Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Teodor Sigaev <teodor(at)sigaev(dot)ru>
Subject: Re: Updated tsearch documentation
Date: 2007-07-25 08:39:35
Message-ID: 200707251039.38273.dfontaine@hi-media.com (view raw or flat)
Thread:
Lists: pgsql-advocacypgsql-hackers
Hi,

Le mercredi 25 juillet 2007, Bruce Momjian a écrit :
> I have added more documentation to try to show how full text search is
> used by user tables.  I think this the documentaiton is almost done:
>
> 	http://momjian.us/expire/fulltext/HTML/textsearch-tables.html

I've come to understand that GIN indexes are far more costly to update than 
GiST one, and Oleg's wiki advice users to partition data and use GiST index 
for live part and GIN index for archive part only.

Is it worth mentioning this into this part of the documentation?
And if mentioned here, partitioning step could certainly be part of the 
example... or let it as a user exercise, but then explaining why GIN is a 
good choice in the provided example.

Hope this helps, regards,
-- 
dim

In response to

Responses

pgsql-hackers by date

Next:From: Dave PageDate: 2007-07-25 08:47:21
Subject: Re: msvc and vista fun
Previous:From: Oleg BartunovDate: 2007-07-25 05:39:57
Subject: Re: Updated tsearch documentation

pgsql-advocacy by date

Next:From: Lukas Kahwe SmithDate: 2007-07-25 09:38:58
Subject: Re: PostgreSQL vs. MySQL: fight
Previous:From: Dave PageDate: 2007-07-25 08:19:24
Subject: Re: PostgreSQL vs. MySQL: fight

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group