Support Min connection pool parameter

[Smriti-OSS]

Hey @brianc @charmander ,

Problem Statement: I have an application which is currently using the default configuration of node-postgres pool to connect to postgres. I have noticed that whenever we query the application - node-postgres connection pool always creates a new connection and so the total time taken for query execution is always between 3-5sec. If we re-use an idle connection for query execution - it just takes 2 millisecond to 300 millisecond.

Proposed Solution: I am thinking of keeping some idle connections in the pool - so that they could be used whenever the database is queried. Something like this -

let pool = new Pool({
        database: connectionConfig.database,
        port: connectionConfig.port,
        user: connectionConfig.user,
        password: connectionConfig.password,
        host: connectionConfig.host,
        min: 1,
        max: 10
    });

I am open to submitting a PR for the above feature but thought of first discussing it with the community whether this would be a feature worth exploring.

[khoirulamri]

I experienced the same problem. each initial set of connections takes more than 200 ms, so the api response time becomes > 1s

[capJavert]

@brianc we are working with pg-pool and would really benefit from this option. My question is, is there any issue on driver level that would block implementing something like that?

I took a brief look at the code and it seems like it should be possible as an addition to pool logic. Would offer to contribute as well 🙌

[htrajan]

I took a crack at addressing this. Would love to get your thoughts @brianc @charmander.