用Postgresql设置elasticSearch [英] setting up elasticSearch with Postgresql

问题描述

我在哪里可以找到如何使用Postgres设置弹性搜索？

where do I find a howto to set up elasticSearch using Postgres?

我的字段大小将是大约350MB，是，MB。我有一个
文本输出所有的美国法典和所有法院的所有决定，
Statutes at Large，几乎所有你会发现在图书馆，
和我需要能够进行全文搜索，并将字段中的确切点
返回到应用程序，以返回PDF格式的确切页面。 Postgres
可以轻松处理数据存储，但我从来没有使用过弹性搜索，而且
不知道它是如何集成到索引等。

My field sizes will be about 350mb, yes, MB, each in size. I have a text output of all of the US Code and all decisions from all the courts, the Statutes at Large, pretty much everything you would find in a library, and I need to be able to do full text searches and return the exact point in the field to the app to return the exact page in PDF form. Postgres can easily handle the datastore, but I've never used elasticSearch and have no idea of how it integrates into the indexing, etc.

推荐答案

截至2015年，有ZomboDB（ https://github.com/zombodb / zombodb ）。作为作者，我有点偏见，但它是相当强大。 ;）

As of 2015, there's ZomboDB (https://github.com/zombodb/zombodb). As the author, I'm a bit biased, but it's quite powerful. ;)

这是一个Postgres扩展和Elasticsearch插件，它允许你使用一个远程Elasticsearch集群的CREATE INDEX，它暴露一个相当强大的查询语言执行全文搜索。

It's a Postgres extension and Elasticsearch plugin that allows you to "CREATE INDEX"s that use a remote Elasticsearch cluster, and it exposes a fairly powerful query language for performing full-text searches.

因为它是Postgres中的实际索引，ES集群会自动与您的INSERT / UPDATE / DELETE记录同步。因此，不需要异步同步过程。

Because it's an actual index in Postgres, the ES cluster is automatically synchronized as you INSERT/UPDATE/DELETE records. As such, there's no need for asynchronous synchronization processes.

此外，因为它是一个实际的索引，它是事务安全的，这意味着并发的Postgres会话只会看到结果

Additionally, because it's an actual index, it is transaction-safe, which means concurrent Postgres sessions will only see results that are consistent with their current transaction.

这是一个链接到ZomboDB的教程。它应该给你一个想法如何容易ZomboDB使用。

Here's a link to ZomboDB's tutorial. It should give you an idea of how easy ZomboDB is to use.

这篇关于用Postgresql设置elasticSearch的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！