Matthias Wirtz

@DrMichael - two ways to solve this i guess - will rework #4019 after i've received your feedback. first: ```sql EXPLAIN ANALYZE WITH last_position AS ( SELECT date, convert_celsius(last_value(outside_temp) over...

@JakobLichterfeld approved by jheredianet by thumbs up ;) could you quickly verify in grafana image and merge before release? Thank you!!!

should be good now 🤔

@JakobLichterfeld - could you have a look?

@JakobLichterfeld - rewrite making use of server_version_num - https://www.postgresql.org/docs/current/runtime-config-preset.html#GUC-SERVER-VERSION-NUM - https://pgpedia.info/s/server_version_num.html - https://www.postgresql.org/docs/current/libpq-status.html#LIBPQ-PQSERVERVERSION

I do not have any env variables within my compose file for the museum container

ok, fine - would you consider a new page in "Guides" on how to backup (eg. daily) with a small backup script, compression options and crontab or is what we...

@JakobLichterfeld - the index on positions date has been created 2019 -> https://github.com/teslamate-org/teslamate/blob/363e5a661612a090cfac5bf89715f7e9de39f420/priv/repo/migrations/20190416125429_add_indexes_on_dates.exs#L5 i'm currently counting 13 pkey indexes and 23 indexes created via migrations in my instance. i compared...

@JakobLichterfeld - small reminder on this one - with all the perf improvements making it into the next release it would be great to mention this issue in the release...

Nice findings - accounting for a fixed buffer of 4.5% is relatively easy - from what i've read so far this buffer varies between different models, age and battery sizes...