ImmichI
Immich•6mo ago
Millo29

Shared albums are slower when browsed by shared users

I have an external library with 1 million photos in 1500 folders and I would like to share it with other users. Since it is almost impossible to display these photos in the user's timeline, the best solution I found was to create albums for each folder and share them with users with the immich-folder-album-creator script, and it worked perfectly.
Now I have 1500 albums shared with users, some folders contain 6000 photos, some 100...
The problem is performance: when I open an album as a shared user, the photos load extremely slowly, while when I open albums as owner user, the loading is extremely fast.
What I noticed when I browse as a shared user is that the PostgreSQL processes are at 100% CPU, and this makes me think that it is not using the indexes of the tables.
How can I solve this issue?
Immich 1.135.3 and Postgres are in docker container with 8 cpus.

This is when i scroll photos in album as a shared user:
    PID USER      PR  NI    VIRT    RES    SHR S  %CPU  %MEM     TIME+ COMMAND
1107153 systemd+  20   0 1869052 691572 619384 R  93.4   8.5  22:08.28 postgres
1355467 systemd+  20   0 1895148 713948 617320 R  93.4   8.8  11:00.19 postgres
1355468 systemd+  20   0 1868528 689296 617564 R  93.4   8.5  10:45.97 postgres
1355469 systemd+  20   0 1867172 688520 617464 R  93.4   8.5  10:11.26 postgres
1355470 systemd+  20   0 1867520 688684 617328 R  93.0   8.5  10:18.53 postgres
1360073 systemd+  20   0 1855040 657564 598580 R  93.0   8.1   1:02.30 postgres
Was this page helpful?