Can Postgresql search full text fast through 3.3 million text documents?

Started by Barbara Ferrellover 24 years ago2 messagesgeneral
Jump to latest
#1Barbara Ferrell
bferrell@washpat.com

We have 3.3 million text documents ( U.S. Patents) that we can put into

any format needed to import into any database needed. Would Postgresql

be able

Show quoted text

to handle fast FULLTEXT searching?

#2jochen mader
jochen@teg-me.de
In reply to: Barbara Ferrell (#1)
Re: Can Postgresql search full text fast through 3.3 million text documents?

On Saturday, 20. October 2001 16:41, you wrote:

We have 3.3 million text documents ( U.S. Patents) that we can put into

any format needed to import into any database needed. Would Postgresql

be able

to handle fast FULLTEXT searching?

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

I just found that there is a way to do fulltextindexing in postgres (it's
stored in the contrib directory of the postgres installation). I think that's
what you are looking for. Has anybody tested that stuff because I don't know
if it's really that fast.

Cya
Jochen