Re: string_to_array eats too much memory?

> I'm testing how GIN scales.

Have a look at http://www.sigaev.ru/cvsweb/cvsweb.cgi/ftsbench/ - utility is 
specially developed for measuring performance of full-text solutions ( now it 
supports PgSQL( GiST, GIN ) and MySQL ). Right now I'm searching good query 
statistic for simulate load, but this data is a closed information in 
internet-wide search engines :(


> ? I thought GIN is superior than tsearch2. 
> 
> From your GIN proposal posted to pgsql-hackers:
> 
> "The primary goal of the Gin index is a scalable full text search in
> PostgreSQL"

GIN itself is a just a tool for speedup searches, linguistic part is still in 
tsearch2.

It's possible to use tsearch2 without any indexes at all. GiST and GIN is  a way 
to speedup searches.

Of course, you can develop another framework for full text search and framework 
may use GIN as it wish :)




-- 
Teodor Sigaev                                   E-mail: teodor@sigaev.ru
  WWW: http://www.sigaev.ru/