[Feature] Dedicated environment variables for the PostgreSQL DB

[kylo32]

I have searched the existing feature requests, both open and closed, to make sure this is not a duplicate request.

• Yes

The feature

I recently migrated my Immich to different hardware and was wondering if I could easily adjust my PostgreSQL database parameters. I cannot find them in the official documentation.
The only way I could adjust (extend) the memory available for the immich_postgres DB was by inputting the "command" section in Docker Compose.
It would help if it could be managed in .env and not a complicated command in the Compose file. For example, I have added:
...
database:
container_name: immich_postgres
image: ghcr.io/immich-app/postgres:14-vectorchord0.4.3-pgvectors0.2.0@sha256:bcf63357191b76a916ae5eb93464d65c07511da41e3bf7a8416db519b40b1c23
#new section
command: >
postgres
-c shared_preload_libraries=vectors.so,vchord.so
-c shared_buffers=4GB
-c work_mem=128MB
-c maintenance_work_mem=1GB
-c effective_cache_size=16GB
...
Maybe it is worth planning to add parameters to environment variables in the future.

Platform

• Server
• Web
• Mobile

[bo0tzz]

Those are bog standard postgres flags and can be found in the postgres documentation.

[kylo32]

Sure, I found it and used.
But maybe still worth being configurable in the Immich env file for optimisation.
For example, if immich will change list of required preload libraries, my config would need to be adapted again. If RAM-related settings are part of easily configurable Immich parameters, it would be much easier.
Immich is providing a dedicated image of PostgreSQL, so it may allow to easely configure it.