Hacker GitHub

← All repos

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

Mentions per year 3 mentions · busiest year 2021 (1)
20082026
  1. It's not Postgresql vs. Elastic, it's Postgresql + Elastic: https://github.com/matthewfranglen/postgres-elasticsearch-fd...
  2. 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
  3. 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