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.