Connection Pooling & Postgres

From reading this post: https://stackoverflow.com/questions/37314264/how-to-automatically-close-mysql-connection-in-servicestack-ormlite?rq=1 and this post: https://stackoverflow.com/questions/44035486/servicestack-orm-db-close-does-not-terminate-the-connection-process.

Is it correct to assume that Pooling=false should be set for anyone using servicestack and ormlite?

I always use connection pooling=true for all RDBMS’s and we run PostgresSQL for https://servicestack.net and our Live Demos that use AWS RDS.

OrmLite doesn’t do any connection pooling itself, when it disposes the ADO.NET IDBConnection which the Npgsql ADO.NET provider returns the open connection to the pool behind-the-scenes. We did have some connection leaking issues with Npgsql but that hasn’t been the case for a long time. So I’d recommend leaving pooling on.

Yeah we’re seeing connection leaks and are trying to figure out where they are coming from, as the instances are all being disposed according to ref counters.

Mythz, do you ever sleep lol.

1 Like

I try to get as much sleep as I can but unfortunately my body is often in disagreement with this and keeps short-circuiting my sleeping patterns :slight_smile:

1 Like