Re: Creation of tsearch2 index is very slow - Mailing list pgsql-general

From Tom Lane
Subject Re: Creation of tsearch2 index is very slow
Date
Msg-id 25034.1137776953@sss.pgh.pa.us
Whole thread Raw
In response to Re: Creation of tsearch2 index is very slow  (Stephan Vollmer <svollmer@gmx.de>)
List pgsql-general
Stephan Vollmer <svollmer@gmx.de> writes:
> Unfortunately, I'm not able to investigate it further myself as I'm
> quite a Postgres newbie. But I could provide someone else with the
> example table. Maybe someone else could find out why it is so slow.

I'd be willing to take a look, if you'll send me the dump file off-list.

> I dropped all unnecessary columns and trimmed the table down to
> 235,000 rows. The dumped table (compressed with RAR) is 7,1 MB. I
> don't have a website to upload it but I could send it to someone via
> e-mail.

Don't have RAR --- gzip or bzip2 is fine ...

            regards, tom lane

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Creation of tsearch2 index is very slow
Next
From: Tony Caduto
Date:
Subject: what am I doing wrong with this query?