A few releases ago they made massive improvements in Speed. I use NC since the Split from OwnCloud and that performance Upgrade recently was truly impressive.

PostgreSQL Updates AFAIK require manual Backup / Restore of the Database. But better look that up. I think the last one I did was:

1. Stop the Application Containers (here the Immich ones, so only PostgreSQL runs)
2. Backup the Database
3. Stop the PostgreSQL Container
4. Change to the new PostgreSQL Version
5. Start the PostgreSQL Container
6. Restore the Database
7. Start the Application Containers

As I said, better look it up first, this is just how I remember the process (but not the backup / restore commands).