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
