U6 slice 3: model identity and in-database vector top-k via pgvector (pin #159) #395

Merged
weichen merged 7 commits from feature/collab-storage-u6-vector into main 2026-10-11 20:25:41 +00:00
Owner

Plan U6 vector slice (KTD11 correctness step), continuation toward completion.

  • backend PR #159: v25 migration (model/content_hash identity; PG best-effort pgvector extension + vec_pg column, absence degrades to in-process scan); dual-write BLOB + vec_pg; model-filtered SQL exact top-k (ORDER BY vec_pg <=> q) with automatic degradation and conservative shared-predicate handling; embedders expose Model() threaded through indexing and both retrieve paths; storage-migrate excludes the derived vec_pg column.

Evidence (SELF via evidence tool in the task card): make test, make test-backend-pg against isolated real PostgreSQL 18.6 + pgvector + Redis (identity/dimension isolation, update/delete atomicity, shared top-k with Recall@10 parity and deny-all leakage checks), make build - all exit 0. CI GATE first run on this PR.

Honest boundaries: HNSW ANN deliberately deferred to U7 measurement-first per KTD11; Chinese full-text mixing unchanged (v4 generated columns).

Task card: .task/feature-collab-storage-u6-vector.md

Plan U6 vector slice (KTD11 correctness step), continuation toward completion. - backend PR #159: v25 migration (model/content_hash identity; PG best-effort pgvector extension + vec_pg column, absence degrades to in-process scan); dual-write BLOB + vec_pg; model-filtered SQL exact top-k (ORDER BY vec_pg <=> q) with automatic degradation and conservative shared-predicate handling; embedders expose Model() threaded through indexing and both retrieve paths; storage-migrate excludes the derived vec_pg column. Evidence (SELF via evidence tool in the task card): make test, make test-backend-pg against isolated real PostgreSQL 18.6 + pgvector + Redis (identity/dimension isolation, update/delete atomicity, shared top-k with Recall@10 parity and deny-all leakage checks), make build - all exit 0. CI GATE first run on this PR. Honest boundaries: HNSW ANN deliberately deferred to U7 measurement-first per KTD11; Chinese full-text mixing unchanged (v4 generated columns). Task card: .task/feature-collab-storage-u6-vector.md
weichen added 5 commits 2026-10-11 20:21:46 +00:00
Why: establish the authorized task workspace and its initial baseline.

Evidence: preserved precheck receipt in .task/feature-collab-storage-u6-vector.md; R0=d8a442edbb8822c85ab79c1a9251f039a8f12880.

Impact: task metadata only; the feature workspace starts at d8a442edbb.

Refs: .task/feature-collab-storage-u6-vector.md
Why: the parent must pin the merged component SHA for combined build and CI.

Evidence: backend origin-main tip e49f165 (includes #159 and later merges) fetched post-recovery; internal core pin 89f3906 matches Dev modules/core.

Impact: gitlink only.

Refs: backend PR #159.
Why: include the current integration baseline before verification.

Evidence: fetched origin/main=dc97048556caebd03168866075d959f0f55d02a7.

Impact: integrate upstream changes without rewriting task history.

Refs: task-sync
Why: bind the task validation checkpoint to the latest integration baseline.

Evidence: SELF recursive component checks; sync_base=dc97048556caebd03168866075d959f0f55d02a7; candidate=9caa8ec8e65ff919c139ff522a5d13f8e882a375.

Impact: task metadata only.

Refs: .task/feature-collab-storage-u6-vector.md
Record the U6 vector delivery state and evidence in the task card
ci / test-pg (pull_request) Successful in 1m14s
ci / test (pull_request) Successful in 2m39s
ba2dad17f5
Why: stage review needs results and evidence in the card before the PR.

Evidence: make test / test-backend-pg (real pgvector) / make build exit 0 via the evidence tool.

Impact: task metadata only.

Refs: backend PR #159.
weichen added 1 commit 2026-10-11 20:22:26 +00:00
Record the U6 vector delivery state and evidence in the task card
ci / test-pg (pull_request) Successful in 1m1s
ci / test (pull_request) Successful in 2m45s
fe93b28c3a
Why: stage review needs results and evidence in the card before the PR merges.

Evidence: make test / test-backend-pg (real pgvector) / make build exit 0 via the evidence tool.

Impact: task metadata only.

Refs: backend PR #159; Dev PR #395.
weichen added 1 commit 2026-10-11 20:22:51 +00:00
Merge authoritative main into the task branch
ci / test-pg (pull_request) Successful in 1m15s
ci / test (pull_request) Successful in 2m41s
687214ac3b
weichen merged commit e7900e1bc7 into main 2026-10-11 20:25:41 +00:00
Sign in to join this conversation.
No Reviewers
No labels
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: weichen/Agent-System-Dev#395