When you mention Postgres, are you saying PG specifically is better, or are you implying that the default SQLite db is what really slows things down? I ask because I’m on mariadb with no complaints, but might switch if NC is faster on Postgres.
It is definitely faster on Postgres. I prefer MariaDB for ease of administration, but NC definitely benefits from postgres. Also, redis helps out a lot.
If you aren’t on the AIO container, seriously consider it. It seems like that’s the way they’re going, and there’s facility for addons (https://github.com/nextcloud/all-in-one/tree/main/community-containers) that you can enable. I’ve put in a request for PGAdmin to be made a part of the community containers. I would do a PR and maintain that but I’m not familiar enough with their plugin setup to risk it.
BTW, could you do with another mod? Because besides you (and Ruud), the mod team is pretty much AFK.