Why would you need a home server in addition to your day to day desktop computer? I leave my desktop on at all times because it’s a Plex/ErsatzTV server, HomeAssistant server, web server for various utilities I’ve written, etc. It works great.
Postgres is a more robust and better designed and developed product, also it’s not owned by fucking Oracle.
It’s simpler code to re-download the file than retrieve what cached version may or may not exist in memory or on disk. Developers often like to keep code simple at the expense of some kinds of efficiency, like this.
An image is usually small enough to be downloaded in no time on a fast connection, which is what developers usually have and don’t stop to think that others might not have.
A video is probably being streamed so earlier segments may no longer be present locally.
Why are frequent restarts healthy? Do you mean at a hardware level or for the OS?