BREAKING CHANGE: This commit require manual adjustments of the database.

```
DROP SCHEMA vectors CASCASE;
DROP EXTENSION vectors;

TRUNCATE TABLE smart_search;
TRUNCATE TABLE asset_faces CASCADE;
TRUNCATE TABLE person;

ALTER TABLE smart_search
ADD COLUMN IF NOT EXISTS embedding vector(512); -- need to change the number here if using a non-default CLIP model

ALTER TABLE asset_faces
ADD COLUMN IF NOT EXISTS embedding vector(512);

SET vectors.pgvector_compatibility=on;

CREATE INDEX IF NOT EXISTS clip_index ON smart_search
    USING hnsw (embedding vector_cosine_ops)
    WITH (ef_construction = 300, m = 16);

CREATE INDEX IF NOT EXISTS face_index ON asset_faces
    USING hnsw (embedding vector_cosine_ops)
    WITH (ef_construction = 300, m = 16);
```

Reference:
https://github.com/immich-app/immich/discussions/7310#discussioncomment-8559595

It's obviously too early to self-host ente. The server has all kinds of
hardcoded defaults that non trivial to see and fix. Need to wait for
upstream. Won't fix it myself with a CLA requirement.