We user AWS RDS Proxy to connect postgres database from Spring Boot.I assume RDS proxy is configured with session pooling.
As RDS proxy is alternative for pgBouncer Spring boot application doesn't worry about connection pool. So it uses SimpleDriverDataSource
It looks like RDS proxy doesn't share the connections between the DB users. Because when I look at pg_stat_activity my spring boot holds many connections even after the restart. This is understandable that rds proxy hold connections rather than the application. Also the client count is zero in RDS proxy metrics. Does it mean RDS proxy never share the connections in the connection pool with other user?
It makes depriving of connections for other applications.
Is there configurations in RDS proxy to release connection to solve this ?
