Re: full text - Mailing list pgsql-general

From Stephen Frost
Subject Re: full text
Date
Msg-id 20200409144122.GR13712@tamriel.snowman.net
Whole thread Raw
In response to full text  (Roberto Della Pasqua <roberto.dellapasqua@live.com>)
List pgsql-general
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

Attachment

pgsql-general by date:

Previous
From: David Gauthier
Date:
Subject: order by not working in view ?
Next
From: Tom Lane
Date:
Subject: Re: order by not working in view ?