Mert

Could you run a few SQL queries for me and share the output for each? ```sql select * from pg_vector_index_stat; ``` ```sql select count(*) from asset_faces; ``` ```sql select count(*)...

You can run `docker exec -it immich_postgres psql --dbname=immich --username=` to connect to the database via the container directly, where `` is the value from your .env file. Then, you...

> @alextran1502 If that was the case, the occupied space would be assigned to Photos and not Immich, no? No, the library the app uses downloads ("caches") assets into the...

The thread pool size isn't really in sharp's control but up to libuv. I do wonder why it's so low - are these threads more expensive than usual or something?...

Thanks, that PR looks very relevant. Immich's [approach](https://github.com/immich-app/immich/blob/c03e72c1da810979e820e7922996f969941dc852/server/start.sh#L26) to this is to run a script before startup to set this environmental variable to the number of CPU cores (respecting cgroups)....

I was thinking of handling this with the `MACHINE_LEARNING_PRELOAD` envs, like with a `MACHINE_LEARNING_PRELOAD__CLIP__TYPE` env that you can set to `textual`. I think it'd be simpler and more generic, although...

> Do we want to offer multiple strategies for when to load the textual model (on client connection, on search bar click...)? I guess loading model may vary a lot...

> I don't think we need to keep around the link live photos job if it's not being used anymore. Can you remove `JobName.LINK_LIVE_PHOTOS` and the associated code? Also, the...

Hi, thanks for the report! Person thumbnails are currently always in JPEG format. We can change this to respect the thumbnail format. However, this isn't problematic in itself and doesn't...

Oh, that's really helpful actually. Could you run this command and share the output? ``` docker exec immich_postgres psql -U postgres -c "SELECT jsonb_pretty(jsonb_build_object('id', a.id, 'type', a.type, 'height', e.\"exifImageHeight\", 'width',...