Pooling connections on postgres

[aseques]

NetBox version

v4.2.3

Feature type

Data model extension

Proposed functionality

I would like to configure connection pooling to the database server (currently there usually around 10 connections always open minimum even if no one is using netbox at the moment)
I haven't been able to find any documentation so far in the docs
https://netboxlabs.com/docs/netbox/en/stable/configuration/required-parameters/#database

Use case

Since postgres has a default connection limit of around 100 connections, having connection pooling would prevent hitting that limit in many cases.

Database changes

No response

External dependencies

No response

[pheus]

NetBox is built on the Django framework, which provides reasonable default database connection settings for most use cases. However, if you need to configure connection pooling, you can refer to the Django documentation, as mentioned in the comments of configuration_example.py.

Keep in mind that the Django version used by your NetBox installation matters. For example, NetBox 4.2 uses Django 5.1, which introduces built-in support for database connection pooling:
🔗 Django 5.1 – PostgreSQL Pooling

For reference, you can check:

• The NetBox configuration_example.py: GitHub Link
• Django's database settings documentation: Django Docs

Hope this helps! 🚀

[aseques]

Thanks a lot for your answer, we are on 4.1.3 and will update to the next version and check if we can configure the pooling.