3 ms·
What about when having different PG database instances that has data you want to join on? Would you still use PG as an aggregated read-only copy of the database
by nugator 10y ago
What about when having different PG database instances that has data you want to join on? Would you still use PG as an aggregated read-only copy of the databases or would you use for example ES?
- brightball 10y agoIt's situational. When you need a search across multiple data sources, standing up a dedicated search engine makes a lot more sense. Then again...PG Foreign Data wrappers would make that scenario pretty simple without the need for an aggregate. I can't speak to performance in that situation though.