7 ms·
Only happens for connections that use FTS and only if you have configured it to use a dictionary (I believe there's no need to in case of an english body). But
by pilif 13y ago
Only happens for connections that use FTS and only if you have configured it to use a dictionary (I believe there's no need to in case of an english body). But keep in mind that this means that you'll have to pay at least 0.5 seconds per search. If you do some google suggest style incremental searching on key press, you'll need to be faster than that.
So either use a persistent connection for full text searching (I'm connecting via pgbouncer for FTS-using connections) or, as karavelov recommended below, use http://pgxn.org/dist/shared_ispell/ http://pgxn.org/dist/shared_ispell/ which will load the dictionary once into shared memory (much less infrastructure needed for this one)
- JohnBooty 13y agoThanks so much for the tip, you saved me some hours for sure!