Re: Questions regarding contrib/tsearch

Tom Lane wrote:
> "Markus Wollny" <Markus(dot)Wollny(at)computec(dot)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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026