[PR #31896] fix(rag): set hnsw.ef_search to fix pgvector TopK limit with filters #33458

Open
opened 2026-02-21 20:53:19 -05:00 by yindo · 0 comments
Owner

Original Pull Request: https://github.com/langgenius/dify/pull/31896

State: open
Merged: No


When using WHERE clause filters with LIMIT in pgvector HNSW index queries, the index may not return enough candidates, causing TopK search to fail.

This fix adds PGVECTOR_HNSW_EF_SEARCH config (default: 100) and sets hnsw.ef_search before each vector search query to improve recall when using filters with LIMIT.

Important

  1. Make sure you have read our contribution guidelines
  2. Ensure there is an associated issue and you have been assigned to it
  3. Use the correct syntax to link this PR: Fixes #<issue number>
    Fix https://github.com/langgenius/dify/issues/31894.

Summary

Screenshots

Before After
... ...

Checklist

  • This change requires a documentation update, included: Dify Document
  • I understand that this PR may be closed in case there was no previous discussion or issues. (This doesn't apply to typos!)
  • I've added a test for each change that was introduced, and I tried as much as possible to make a single atomic change.
  • I've updated the documentation accordingly.
  • I ran make lint and make type-check (backend) and cd web && npx lint-staged (frontend) to appease the lint gods
**Original Pull Request:** https://github.com/langgenius/dify/pull/31896 **State:** open **Merged:** No --- When using WHERE clause filters with LIMIT in pgvector HNSW index queries, the index may not return enough candidates, causing TopK search to fail. This fix adds PGVECTOR_HNSW_EF_SEARCH config (default: 100) and sets hnsw.ef_search before each vector search query to improve recall when using filters with LIMIT. > [!IMPORTANT] > > 1. Make sure you have read our [contribution guidelines](https://github.com/langgenius/dify/blob/main/CONTRIBUTING.md) > 1. Ensure there is an associated issue and you have been assigned to it > 1. Use the correct syntax to link this PR: `Fixes #<issue number>` Fix https://github.com/langgenius/dify/issues/31894. ## Summary <!-- Please include a summary of the change and which issue is fixed. Please also include relevant motivation and context. List any dependencies that are required for this change. --> ## Screenshots | Before | After | |--------|-------| | ... | ... | ## Checklist - [ ] This change requires a documentation update, included: [Dify Document](https://github.com/langgenius/dify-docs) - [x] I understand that this PR may be closed in case there was no previous discussion or issues. (This doesn't apply to typos!) - [x] I've added a test for each change that was introduced, and I tried as much as possible to make a single atomic change. - [x] I've updated the documentation accordingly. - [x] I ran `make lint` and `make type-check` (backend) and `cd web && npx lint-staged` (frontend) to appease the lint gods
yindo added the pull-request label 2026-02-21 20:53:19 -05:00
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: langgenius/dify#33458