You're the reason why I inherit project that uses only ES and then end up doing relational schema in ES because they didn't use relational database in general.
If you had to choose between PostgreSQL or ElasticSearch then you have no idea what you're doing.