Le mercredi 21 février 2007 15:44, Tom Lane a écrit :
> Markus Schiltknecht <[EMAIL PROTECTED]> writes:
> > Henrik Zagerholm wrote:
> >> Is this normal? What can I tweak in postgresql.conf to speed up big
> >> to_tsvector()?
> >
> > Hm.. seems not too unreasonable to me.
> > Take a look at the stem
21 feb 2007 kl. 15:44 skrev Tom Lane:
Markus Schiltknecht <[EMAIL PROTECTED]> writes:
Henrik Zagerholm wrote:
Is this normal? What can I tweak in postgresql.conf to speed up big
to_tsvector()?
Hm.. seems not too unreasonable to me.
Take a look at the stemmers or dictionaries involved. What
Markus Schiltknecht <[EMAIL PROTECTED]> writes:
> Henrik Zagerholm wrote:
>> Is this normal? What can I tweak in postgresql.conf to speed up big
>> to_tsvector()?
> Hm.. seems not too unreasonable to me.
> Take a look at the stemmers or dictionaries involved. What do you use there?
Also, I wonde
On Wed, 21 Feb 2007, Henrik Zagerholm wrote:
Hello list,
I've been testing tsearch2 for a while and I recently noticed some really
slow queries.
This is a quite big document so the times are maybe accurate.
The document has about 194 000 words.
I put all the data in tbl_fulltext.fulltext_t
Hi,
Henrik Zagerholm wrote:
Which takes about 80 seconds to complete.
The hardware is a Pentium 4 2.8GHz with 1GB HyperX memory.
Is this normal? What can I tweak in postgresql.conf to speed up big
to_tsvector()?
Hm.. seems not too unreasonable to me.
Take a look at the stemmers or dictionar
Henrik Zagerholm wrote:
The document has about 194 000 words.
update tbl_fulltext set vectors = to_tsvector(fulltext_text);
Which takes about 80 seconds to complete.
The hardware is a Pentium 4 2.8GHz with 1GB HyperX memory.
Is this normal? What can I tweak in postgresql.conf to speed up big
Hello list,
I've been testing tsearch2 for a while and I recently noticed some
really slow queries.
This is a quite big document so the times are maybe accurate.
The document has about 194 000 words.
I put all the data in tbl_fulltext.fulltext_text and then did a
update tbl_fulltext set ve