Re: Questions regarding contrib/tsearch

Tom Lane wrote:
> "Markus Wollny" <Markus.Wollny@computec.de> writes:
> > ... I suspect that the high running
> > time for the first call of that query is due to the database having to
> > do harddisk-access in order to get the needed parts of the table into
> > memory. This would explain the acceptably low running time of the second
> > call - the information needed is already in memory, so there's no slow
> > harddisk-access involved and the query is completed quite quickly. Is
> > this correct?
>
> Yup, that's my interpretation as well.

Also, is there any mention in the tsearch documentation about clustering
the index?  Does that help performance.  I know it helped in other
full-text indexes.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026