postgres text search

Question

We have a search feature that allows users to search based on product description. The table could countain around 2m rows. Do i need to implement full text search for this or do I just need a regular index on the description col.

question 2. is there a tool that will generate 2m records.

Thanks in advance.

user330315 · Accepted Answer · 2010-12-29 11:46:51Z

2

I agree with Frank: you will not get far without full-text search. A "regular index" will not help at all because any "user-friendly" search needs to do partial matching (LIKE '%somevalue%') and this will never use an index

For generating test data, I have good experience with Benerator. It's a bit complicated to learn, but very powerful.

Alternatively you can use Datagenerator which is actually an Oracle tool, but can produce flat files as well that can be used with Postgres

answered Dec 29, 2010 at 11:46

user330315

Sign up to request clarification or add additional context in comments.

2 Comments

user373201 Over a year ago

Thanks for the answer, the wiki site says there are two types of FTS contrib/fulltextindex and contrib/tsearch. Any ideas as to which one is easy and efficient to implement. Also what is the learning curve to use one of the following

user330315 Over a year ago

contrib/tsearch is deprecated since 8.3 (8.4?) everything is now built-in. See the link that Frank posted

Frank Heikens · Accepted Answer · 2010-12-29 11:36:37Z

1

When a "regular index" is a B-Tree-index, than this will not help in the search. You need FTS to search for content in a piece of text.

http://www.postgresql.org/docs/current/interactive/textsearch.html

answered Dec 29, 2010 at 11:36

Frank Heikens

129k26 gold badges157 silver badges153 bronze badges

Collectives™ on Stack Overflow

postgres text search

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related