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

New Issue

2025-11-11T16:32:10-06:00

GiteaMirror commented

2025-11-11 16:32:10 -06:00

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

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

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

GiteaMirror closed this issue

2025-11-11 16:32:11 -06:00

GiteaMirror commented

2025-11-11 16:32:11 -06:00

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

PR welcome!

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