Domi

That’s the thing I don’t like about Postgres either. The performance is significantly better than with MariaDB but Postgres is such a pain for non-enterprise use.

Same with crash recovery, Postgres just can’t recover if the WAL is corrupted. MariaDB will happily fix itself but Postgres will just sit there and wait until somebody babysits it.

So you better spin up a second Postgres container, run pg_resetwal, restart the database and terminate any open transactions manually with a 2 page query you hopefully wrote down. Might reindex all tables as well to be sure.

I have a separate “postgres unfuck” script by now.

As much as I hate the guy, that just says exactly what I just said, the range is optimistic by default. Which is how every brand new EV I have ever been in measures its range when not moving/navigating, if estimated range is even shown.

Applies to non-EVs as well, they don’t go: “we will show the worst possible range estimation so we look bad”. They show the range estimate of an old granny going 30 in a beautiful Californian summer and then slowly correct it once more data is available.

The range in the dashboard is optimistic because the car does not know where you are going. The range in the navigation is pessimistic and usually spot on within ± 2%.

Are you running podman rootless? Maybe a permission issue?