Hacker News new | past | comments | ask | show | jobs | submit login

I went a similar route (Postgres for CRUD and Elastic for searching) and also underestimated the effort of keeping the two datastore in sync as well as underestimated the effort in maintaining a reliable Elastic cluster with limited manpower/experience. After moving to Postgres full text search with indexes and query boosting, I accomplished everything I needed inside Postgres with update triggers and search queries that were incredibly performant.



Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: