3 ms·
ES is very good at storing and querying non-text data including geo data although there are exceptions such as numeric. Both PG and ES have their strengths and
by rpedela 9y ago
ES is very good at storing and querying non-text data including geo data although there are exceptions such as numeric. Both PG and ES have their strengths and weaknesses. ES is great at search. PG is great at joins and constraints. Everything else depends a lot on the specific use case.
- jeltz 9y agoYes, both databases can handle all kinds of data and have support for a wide range of index types, but ES does not come anywhere close to PostGIS when it comes to geodata. PG is superior at search for geodata, while ES is superior at text search.