Re:PostgreSQL 11 and Just in Time Compilation of Queries
by mmt on Tuesday September 11, 2018 @10:47PM
(#17965242)
I recently interviewed at a startup that explicitly uses both, with PG being something of an authoritative backend store that feeds into ES as the primary frontend store (since the frontend is search-heavy).
It might be possible to get it to work without PG, but I imagine it would require a huge engineering effort (akin to an entire product on its own, which, IIRC, is what CrateDB is).
(Although I believe I understand your point, I fear that your tone and ad-hominem language detracts from it).
Re:PostgreSQL 11 and Just in Time Compilation of Queries
by shawn-butler on Wednesday September 12, 2018 @01:44AM
(#17965824)
https://github.com/zombodb/zombodb works for me by turning Elasticsearch into an index type (PG10 only)
If you had to choose between PostgreSQL or ElasticSearch then you have no idea what you're doing.