4 ms·
Regarding point 2: Shouldn't you be moving your search queries from your transaction server to a separate analysis or read-replica server? OLTP copies to OLAP
by NortySpock 5y ago
Regarding point 2:
Shouldn't you be moving your search queries from your transaction server to a separate analysis or read-replica server? OLTP copies to OLAP and suddenly you've separated these two problems.
- blowski 5y ago…and created a new one if the projection is only eventually consistent. No free lunches here.
- zepolen 5y agoHow is that different from running Postgres and Elasticsearch separately?
- blowski 5y agoIt’s not. It’s a difference between having separate OLAP and OLTP databases, which is what the parent post suggested.
- justinclift 5y agoProbably skill set of staff? For example, if a place has developed fairly good knowledge of PG already, they can "just" (!) continue developing their PG knowledge. Adding ES into the mix though, introduces a whole new thing that needs to be learned, optimised, etc.