feat: Add Configurable Pool Size and Max Overflow for Pgvector Database #5742

Closed
opened 2025-11-11 16:32:10 -06:00 by GiteaMirror · 1 comment
Owner

Originally created by @calebhansard on GitHub (Jul 11, 2025).

Check Existing Issues

  • I have searched the existing issues and discussions.

Problem Description

The current Open WebUI application database allows configuration of the PostgreSQL database pool size and max overflow for the application database. However, similar configuration options are not available for the pgvector database. This limits the ability to manage database connections and tune performance specifically for the pgvector database.

Desired Solution you'd like

Add support for configurable pool size and max overflow for the pgvector database. This would allow users to better manage database connections and potentially improve performance.

Alternatives Considered

No response

Additional Context

Originally created by @calebhansard on GitHub (Jul 11, 2025). ### Check Existing Issues - [x] I have searched the existing issues and discussions. ### Problem Description The current Open WebUI application database allows configuration of the PostgreSQL database pool size and max overflow for the application database. However, similar configuration options are not available for the pgvector database. This limits the ability to manage database connections and tune performance specifically for the pgvector database. ### Desired Solution you'd like Add support for configurable pool size and max overflow for the pgvector database. This would allow users to better manage database connections and potentially improve performance. ### Alternatives Considered _No response_ ### Additional Context - Application db code: https://github.com/open-webui/open-webui/blob/5eca495d3e3b3066e7831141ed2adffbd6d179b4/backend/open_webui/internal/db.py#L78-L97 - pgvector db code: https://github.com/open-webui/open-webui/blob/5eca495d3e3b3066e7831141ed2adffbd6d179b4/backend/open_webui/retrieval/vector/dbs/pgvector.py#L74-L131 - SQAlchemy connection pooling: https://docs.sqlalchemy.org/en/20/core/pooling.html
Author
Owner

@tjbck commented on GitHub (Jul 12, 2025):

PR welcome!

@tjbck commented on GitHub (Jul 12, 2025): PR welcome!
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/open-webui#5742