As a counterpoint, I’m not sure what everybody is doing to their Nextcloud installs. Many people have problems so I believe they are real, but I’m not sure where I’ve gone so right.

Right now I use Docker compose, with the major version pinned so it doesn’t surprise me. I verify app compatibility before changing that major version.

I use PostgreSQL as the DB.

I've never had real problems with it, and it wasn't for lack of trying.

I've been using Nextcloud since it forked from OwnCloud, and I was running OwnCloud before that. It was on a NAS with 64MB RAM and a 500MHz CPU at one point.

I've run it bare metal, with different Linux distros, on FreeBSD, in VMs, in LXC containers, in Docker containers, with different PHP versions, with different web servers, with different DBs, on terrible hardware, on powerful hardware, more. So many combinations.