What happened with Elasticsearch?

Not OP, but you'll run into issues with write throughout at some point, usually. Inverted indexes are nice, but writes are expensive.

Also not GP, but imo ElasticSearch is meant to serve one thing: provide search. It's not intended as your primary storage and source of truth which OLTP databases like PostgreSQL and MySQL are designed for.