Thread: full text
Please sorry because I’m newbie of PGSQL
I need the best performing and overall quality full-text search, can be possible to have the data stored in pgsql and the index to elasticsearch? Can be in sync between?
Thank you
Btw. Do you suggest another engine than elastic?
Roberto Della Pasqua
Please sorry because I’m newbie of PGSQL
I need the best performing and overall quality full-text search, can be possible to have the data stored in pgsql and the index to elasticsearch? Can be in sync between?
Thank you
Btw. Do you suggest another engine than elastic?
Roberto Della Pasqua
according to programcreek you can create an index from a <Seldon|Postgres> jdbc source
https://www.programcreek.com/java-api-examples/?code=SeldonIO/semantic-vectors-lucene-tools/semantic-vectors-lucene-tools-master/src/main/java/io/seldon/semvec/CreateLuceneIndexFromDb.java
This page provides Java source code for CreateLuceneIndexFromDb. www.programcreek.com |
Buona Fortuna!
martini
Sent: Wednesday, April 8, 2020 1:28 PM
To: pgsql-general@postgresql.org <pgsql-general@postgresql.org>
Subject: full text
Please sorry because I’m newbie of PGSQL
I need the best performing and overall quality full-text search, can be possible to have the data stored in pgsql and the index to elasticsearch? Can be in sync between?
Thank you
Btw. Do you suggest another engine than elastic?
Roberto Della Pasqua
Greetings, * Roberto Della Pasqua (roberto.dellapasqua@live.com) wrote: > Please sorry because I'm newbie of PGSQL We all were, once upon a time. :) > I need the best performing and overall quality full-text search, can be possible to have the data stored in pgsql and theindex to elasticsearch? Can be in sync between? [...] > Btw. Do you suggest another engine than elastic? PG's got some rather good built-in full-text search capabilities, you really should consider them before you look to something outside of PG, since you'd then have, as you say, to deal with sync'ing things between the database and something external, not to mention having to run an additional service on top of already running PG. https://www.postgresql.org/docs/current/textsearch.html Thanks, Stephen