Home Assistant Core’s database received possibly its biggest update ever in last April’s stable release. With that release, it’s size shrunk by 10-35% for most installs, and data displayed in the dashboard loaded much faster than previously. Home Assistant Core 2022.6 builds on the previous developments and improves the database performance yet again.
To start off with, the database will see a significant reduction in size. This time around, the estimate is at 25-40% for most installs. That is on top of what already was shaved off in April. Don’t expect an immediate impact, as the size reduction will occur over time with the recording of new data and the purging of old data. The developers achieved this impressive reduction by only storing references instead of the whole event data, if the same data already exists in the database.
Disk writes are also reduced, which will hopefully preserve the SD cards for those running Home Assistant OS on a Raspberry Pi. At the same time, the history of an entity and the logbook should load faster when viewed. All in all, Home Assistant 2022.6 once again brings impressive under the hood changes, which will make it much more enjoyable to use.