How to do searches with Elasticsearch/PostgreSQL?

Question

PostgreSQL

I have a base with products

CREATE TABLE products (
id BIGSERIAL NOT NULL PRIMARY KEY,
title VARCHAR(100) NOT NULL,
description TEXT NULL,
price BIGINT NOT NULL
);

How to make it so that when adding / changing in PostgreSQL, the data is automatically updated in Elasticsearch?

Answer 1

The easiest way is to send data from the code to Elasticsearch and PostgreSQL in parallel. And you can pile up the system from a trigger, a notification mechanism and a handler for these notifications, which will send data to Elasticsearch. But it won't be easy.

Answer 2

reindex only changed ones!

1. in add columns PostgreSQLlast_update products(timestamp) and indexed (1/0)
   
2. save in the Elasticsearchproduct ID, be sure to understand it and the selection will take place.
   
3. store last indexing time, global value for the entire index.
   
4. run a daemon program that reindexes changed products.