fix(db): index the keyword projection by document, and drop the unrea… #32421

Job	Run time
Detect Desktop Changes	16s
Detect Version	6s
Test and Build / Test (shard 3)	3m 13s
Build AMD64 (./docker/pii.Dockerfile, ghcr.io/simstudioai/pii, ECR_PII, ubuntu-latest, blacksmith...	43s
Prepare Trigger.dev	9m 4s
Build AMD64 (./docker/cron.Dockerfile, ghcr.io/simstudioai/cron, ubuntu-latest, blacksmith-2vcpu-...	21s
Build AMD64 (./docker/realtime.Dockerfile, ghcr.io/simstudioai/realtime, ECR_REALTIME, ubuntu-lat...	1m 43s
Build AMD64 (./docker/app.Dockerfile, 102400, ghcr.io/simstudioai/simstudio, ECR_APP, linux-x64-8...	4m 5s
Build AMD64 (./docker/db.Dockerfile, ghcr.io/simstudioai/migrations, ECR_MIGRATIONS, ubuntu-lates...	40s
Test and Build / PostgreSQL integration (migrate)	4m 53s
Test and Build / Build App	3m 52s
Test and Build / PostgreSQL integration (push)	4m 19s
Test and Build / Test (shard 2)	2m 46s
Test and Build / Lint and Test	5m 1s
Build ARM64 (GHCR Only)	-1s
Check Docs Changes	-6s
Migrate Dev DB	-7s
Build Dev ECR	-10s
Check Desktop Signing Secrets	-1s
Create Desktop Prerelease	-1s
Desktop Prerelease Build	0s
Publish Desktop Prerelease	0s
Prune Desktop Prereleases	0s
Migrate DB / Apply Database Migrations	45s
Promote Images	33s
Promote Trigger.dev	3m 34s
Process Docs	-1s
Create GHCR Manifests	-1s
Resolve Attestation Subjects	-1s
Attest Images	0s
Create GitHub Release	0s
Desktop Release	0s
	45m 25s

Navigation Menu