Expose additional db connection configurations (min connections, min idle connections, etc)

[robindefaye]

Is your feature request related to a problem? Please describe.
We have seen lots of strange constant cycling of connections even though we have quite long max connection times and max idle connection times. Which causes a lot more long connect times.

Describe the solution you'd like
We would like more of the pgx pool configurations exposed so that we can make more adjustments to how the pooling is handled.

Describe alternatives you've considered
We have tried both with a proxy(AWS RDS Proxy) and without with varying configurations but the issue continues to persist.

[tolgaozen]

Hi @robindefaye ,

We've added more pgxpool configuration options to help with connection cycling. You can now configure:

• min_connections - Minimum connections (keeps pool warm, prevents cycling)
• min_idle_connections - Minimum idle connections (ensures ready connections)
• max_connections - Maximum connections (replaces max_open_connections)
• health_check_period - Health check frequency (default: 1m)
• max_connection_lifetime_jitter - Prevents simultaneous connection expirations
• connect_timeout - Connection establishment timeout

Example Configuration

database:
  .
  max_connections: 20
  min_connections: 5                      # Prevents pool from shrinking to zero
  min_idle_connections: 3                 # Keeps ready connections available
  max_connection_lifetime: 3600s
  max_connection_idle_time: 300s
  max_connection_lifetime_jitter: 600s    # Prevents thundering herd
  health_check_period: 30s                # Early detection of broken connections
  connect_timeout: 10s

Deprecated Parameters & Backward Compatibility

• max_open_connections → deprecated, use max_connections instead (still works)
• max_idle_connections → deprecated, use min_connections instead (still works, maps to min_connections if not set)

Your existing configs will continue to work. The new parameters use pgx defaults (0) when not set.

Try with the latest image: ghcr.io/permify/permify-beta:v1.5.2-f51cc99f

[tolgaozen]

Hi @robindefaye, did you get a change to try it out?