sirkarthik

Historically speaking, in which countries in the past, did FIIs withdrew big time? Why did they do that and what were the consequences of their action on that country?

I would appreciate factual answers with references to news articles for further reading and exploration.

AFAIK, most DBs don't have a built-in mechanism to measure TPS (Transaction Per Second) of a DB. So, I'm curious how your team computes it to measure the scaling of your DB.

One of my clients sync PostgreSQL DB (RDBMS) data with ElasticSearch. Because of DB overload, they have started migrating big SELECT queries (that have joins and aggregations in it) to APIs that read data from ElasticSearch.

Is this not an anti-pattern? Isn't it easier and nicer to read this data from PostgreSQL Read Replica instead of reading from ElasticSearch??