Обсуждение: full text

Поиск
Список
Период
Сортировка

full text

От
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

www.dellapasqua.com

 

Re: full text

От
Joshua Drake
Дата:
Roberto,

I would look at ZomboDB: https://www.zombodb.com/ . Which is exactly what you suggest.

JD

On Wed, Apr 8, 2020 at 10:28 AM Roberto Della Pasqua <roberto.dellapasqua@live.com> wrote:

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

www.dellapasqua.com

 

Re: full text

От
Martin Gainty
Дата:
i dont know how to do with elastic-search

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
its up to you to determine the jdbc connection attributes from Postgres

Buona Fortuna!

martini


From: Roberto Della Pasqua <roberto.dellapasqua@live.com>
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

www.dellapasqua.com

 

Re: full text

От
Stephen Frost
Дата:
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
Вложения