From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Markus Wollny <Markus(dot)Wollny(at)computec(dot)de>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Questions regarding contrib/tsearch |
Date: | 2002-08-03 01:22:40 |
Message-ID: | 200208030122.g731MfO09078@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2002-08-03 01:30:25 | Re: Open Source Conference Talks Online |
Previous Message | ljb | 2002-08-03 00:38:39 | Re: varchar truncation from 7.1 to 7.2 |