Your Home Assistant database is about to get even leaner

Disclosure: This post contains affiliate links. If you click through and make a purchase, I’ll earn a commission, at no additional cost to you. Read my full disclosure here.
Advertisement

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.

Advertisement

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.

Advertisement
Advertisement
Liam Alexander Colman, the author and maintainer of Home Assistant Guides.

About Liam Alexander Colman

Liam Alexander Colman has been using Home Assistant for various projects for quite some time. What started off with a Raspberry Pi quickly became three Raspberry Pis and eventually a full-blown server. I now use Unraid as my operating system, and Home Assistant happily runs in a Docker container. My personal setup includes many Zigbee devices as well as integrations with existing products such as my Android TV box. Read on to find out more on how I got started with Home Assistant.

Leave a comment

Advertisement
Share to...