This is my one big problem with Postgres. Their heavy client/thread model prevents these sort of architecture where you may have a large number of connections.

This is my one big problem with Postgres. Their heavy client/thread model prevents these sort of architecture where you may have a large number of connections. PGBouncer helps a lot, but it's not quite the same.