Database to store history?

Question

Django

Hello! I am doing a project on django where many users will create new entries in the database every day, over time the database will become heavier and heavier, the project has a user action history functionality, and I would like to move it to a separate database. What solutions are used in such cases? Or doesn't it make sense to separate the data? The main database hangs on Postgresql, plus there is redis for cache storage.

Answer 1

у вас история в отдельной таблице хранится. если есть редко используемые данные разбейте таблицу postgresql.ru.net/manual/ddl-partitioning.html
но скорей всего правильно вам написали, не нужно оно еще вам.