Hello All, Need some help on theoretical perspective. I need to know where pinot store the data, it's like since pinot keeps very new data inside it self and after some time it push it back to some where else. What I need to know this other DB where old data remains . Can I use postgreSQL for that one

Pinot has its own storage, it does not use other DBs to store data.

But it does also keep a copy of each segment in what’s called the Deep Store - https://docs.pinot.apache.org/basics/components/deep-store

Yes, that is still in Pinot’s own storage format, and hence not queryable by other DBs

@Mayank If you want to query data by other DBs you need to load the data into them. Pinot is a database, it is not a database front end.

@Michael Latta Yes, that’s correct 🙂