node-postgres: Setting max connection pool size

Question

node-postgres: Setting max connection pool size

I can't find any documentation for the node-postgres drive on setting the maximum connection pool size, or even finding out what it is if it's not configurable. Does anyone know how I can set the maximum number of connections, or what it is by default?

postgresql
node.js
connection-pooling

Answer 1

defaults are defined in node-postgres/lib/defaults https://github.com/brianc/node-postgres/blob/master/lib/defaults.js

poolSize is set to 10 by default, 0 will disable any pooling.

var pg = require('pg');
pg.defaults.poolSize = 20;

Note that the pool is only used when using the connect method, and not when initiating an instance of Client directly.

Answer 2

node.js is single threaded why want to have more then 1 connection to db per process ? Even when you will cluster node.js processes you should have 1 connection per process max. Else you are doing something wrong.