matthewfranglen/postgres-elasticsearch-fdw
View on GitHub ↗ ★ 124 Python
Postgres to Elastic Search Foreign Data Wrapper
3 mentions on Hacker News by 3 people: 0 stories, 3 comments · first 2021-11-10 · latest 2023-07-19
20082026
-
It's not Postgresql vs. Elastic, it's Postgresql + Elastic: https://github.com/matthewfranglen/postgres-elasticsearch-fd...
comment by forinti · 2023-07-19 · in Full-text search engine with PostgreSQL (part 2): Postgres vs. Elasticsearch -
My experience with Postgres FTS (did a comparison with Elastic a couple years back), is that filtering works fine and is speedy enough, but ranking crumbles when the resulting set is large. If you have a large-ish data set with lots of…
comment by soft_dev_person · 2022-10-15 · in Postgres Full Text Search vs. the Rest -
I used a foreign data wrapper to query elasticsearch indexes from within postgres.[0] It pushed alot of complexity down away from higher-level app developers not familiar with ES patterns. [0]: https://github.com/matthewfranglen/postgres-el…
comment by shawn-butler · 2021-11-10 · in Lesser-known Postgres features