Is it normal to store logs in the main database?

Question

PostgreSQL

Good afternoon!
I ran into a question .. the essence is as follows. There are logs of service users that are needed for further processing (perhaps, you need to store the last 2-3 months), about 250k records run a day, in the future, it can grow to 20-30 million. Now they are stored in the same database as user data, there is a certain desire to take it somewhere. The data has a clear structure, so I don’t see any advantages for choosing noSQL .. Maybe
someone will tell you something from personal experience . they cannot be called very important, more a guide to what users use (and how much). In the future, most likely we will build forecasts based on these data (using machine learning)
Thank you for your attention! I apologize for the style of writing the question (early morning, falling asleep)

Answer 1

Store as text
Upload to a subpack an hour / day / week
before uploading Normalize before uploading
What you will cheat in the end - no one knows
So watch the timings of the main requests

Answer 2