[PR #13876] Feat: Add pg_bigm for keyword search in pgvector #28070

Closed
opened 2026-02-21 20:42:44 -05:00 by yindo · 0 comments
Owner

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

State: closed
Merged: Yes


Summary

Resolves #13873

This pull request adds new keyword search method by pg_bigm and introduces the environment variable PGVECTOR_PG_BIGM that is false by default. When setting PGVECTOR_PG_BIGM to true, keyword search by pg_bigm is enabled.

When selecting pgvector for vector store, the keyword search method based on tsvector can already be used. But, this method does not support Japanese by default. This pull request enables keyword search by Japanese or maybe other languages that is not supported by tsvector approach.

Checklist

Important

Please review the checklist below before submitting your pull request.

  • 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 dev/reformat(backend) and cd web && npx lint-staged(frontend) to appease the lint gods
**Original Pull Request:** https://github.com/langgenius/dify/pull/13876 **State:** closed **Merged:** Yes --- # Summary Resolves #13873 This pull request adds new keyword search method by [pg_bigm](https://github.com/pgbigm/pg_bigm) and introduces the environment variable `PGVECTOR_PG_BIGM` that is `false` by default. When setting `PGVECTOR_PG_BIGM` to `true`, keyword search by pg_bigm is enabled. When selecting pgvector for vector store, the keyword search method based on [tsvector](https://www.postgresql.org/docs/16/datatype-textsearch.html#DATATYPE-TSVECTOR) can already be used. But, this method does not support Japanese by default. This pull request enables keyword search by Japanese or maybe other languages that is not supported by tsvector approach. # Checklist > [!IMPORTANT] > Please review the checklist below before submitting your pull request. - [ ] 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!) - [ ] 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. - [x] I ran `dev/reformat`(backend) and `cd web && npx lint-staged`(frontend) to appease the lint gods
yindo added the pull-request label 2026-02-21 20:42:44 -05:00
yindo closed this issue 2026-02-21 20:42:44 -05:00
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: langgenius/dify#28070