Home-assistant_v2.db is growing more and more!

[peuxman]

Hello everybody !

I have a little problem with my HA local database (home-assistant_v2.db) : it’s too big for my computer !
It’s about 3Go now and it’s increasing by 1Go per day…

I’ve set the recorder with these attributes :

recorder:
  auto_purge: true
  purge_keep_days: 1
  commit_interval : 60
  include: 
    domains:
      - sensor

But nothing has changed !

Can someone help me to fix it ?

Thanks

[joselito1 (jose litomans)]

My db is 20GB

[tom_l]

How to reduce your database size and extend the life of your SD card

Preamble: @tom_l is the original author of this community guide. He proposed an analytical approach to decide for each entity_id whether to include or exclude it from the underlying database. @mbuscher suggested to go after the entities most often updated in the database, and exclude only those. Both approaches are now included in this community guide. Target audience: anyone who uses an installation on flash memory like a Raspberry Pi with an SD card or an SSD drive, or anyone who wishes to re…