Re: [PERFORM] How to speed up tsearch2 indexing

On Wed, 9 Mar 2005, Werner Bohl wrote: On Wed, 2005-03-09 at 20:41 +0300, Oleg Bartunov wrote: What's your tsearch2 configuration ? Do you use dictionaries ? I wrote a brief explanation of tsearch2 internals http://www.sai.msu.su/~megera/oddmuse/index.cgi/Tsearch_V2_internals Tsearch2 is using defa

Re: [PERFORM] How to speed up tsearch2 indexing

On Wed, 2005-03-09 at 20:41 +0300, Oleg Bartunov wrote: > What's your tsearch2 configuration ? Do you use dictionaries ? > I wrote a brief explanation of tsearch2 internals > http://www.sai.msu.su/~megera/oddmuse/index.cgi/Tsearch_V2_internals > Tsearch2 is using default english configuration. No

Re: [PERFORM] How to speed up tsearch2 indexing

On Wed, 9 Mar 2005, Werner Bohl wrote: All, I have a table with ~ 3 million records. I'm indexing a field holding names, no more than 200 bytes each. Indexing the resulting tsvector takes forever. It's been running now for more than 40 hours on a Linux with PG 8.01, a single Xeon & 4GB RAM. My wor

[PERFORM] How to speed up tsearch2 indexing

All, I have a table with ~ 3 million records. I'm indexing a field holding names, no more than 200 bytes each. Indexing the resulting tsvector takes forever. It's been running now for more than 40 hours on a Linux with PG 8.01, a single Xeon & 4GB RAM. My work_mem postgresql.conf parameter is at