I've been doing "serverless" on app engine for more than a decade and it handles postgres connections fine without any heroics.

There's always instances with state somewhere; it's just a question of how smart your serverless infrastructure is about pooling the instances.