Dear Sirs, I’ve a raspberry with Openhab 3 running fine from 2021, for persistence I’ve setup a remote Postgresql 14 server but the openhab database has become huge 8 GB on disk. Is there any cleaning tool in the addon (i.e. a setting to keep data for 365 days) ? Thanks, BR

Amount of data depends on amount of probes you have. 8GB seems to be big number, however you can do some basic cleanups - first of all try running postgres vacuum to cleanup internal storage. Sometimes it helps. Then, if you still have a lot of storage occupied - look for specific items which have …

Thank you @splatch , there were two itemxx who filled up that huge amount of space: item01: a disabled camera item that was taking a snaphsot after another item02: spotify track duration time that add a row each time a second is passed while playing a song I didn’t find any “ignore for persistence…

[image] SummerSea: I didn’t find any “ignore for persistence” settings so I’ve deleted thos items and now everything seems light and clean. Persistence configuration works the other direction. You can define what Items to save and how but you cannot define “every Item except…”. So if you want…

Postgresql huge space used by openhab

Add-ons Persistence Services

splatch (Łukasz Dywicki) June 6, 2023, 2:36pm 5

4.0 ships some updates to item persistence configuration, if you are on earlier versions then you are probably victim of situation I was writing about back in August 2021: