There ends up being some overlap in most cases, especially if something like elastic search is used to look up Postgres records. However, they're not perfectly duplicate rows, usually different pieces of data referring to the same user/post/or other record.
I have more or less the same data in Elastic as what's in MySQL (sans the HTML, stop words and such), and a similar scheme for the caching in Redis, so that's a fair bit of overlap.
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
Do you duplicate data for different types of database?
There ends up being some overlap in most cases, especially if something like elastic search is used to look up Postgres records. However, they're not perfectly duplicate rows, usually different pieces of data referring to the same user/post/or other record.
I have more or less the same data in Elastic as what's in MySQL (sans the HTML, stop words and such), and a similar scheme for the caching in Redis, so that's a fair bit of overlap.