2 ms·
Not just that. PostgreSQL also offers a clear advantage if you need to access both full text data and relational or geographical data in the same query. On the
by jeltz 10y ago
Not just that. PostgreSQL also offers a clear advantage if you need to access both full text data and relational or geographical data in the same query.
On the other hand what you say is true, ES is much more flexible in what it can offer in full text search.
- rpedela 10y agoES 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 10y 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.