I feel the lack of index-only queries. As for lightweight connections, I see this as completely moot. While you might make tens of thousands of cheap connecti

I feel the lack of index-only queries. As for lightweight connections, I see this as completely moot. While you might make tens of thousands of cheap connections to a mysql server, postgresql is much better at executing concurrent queries. Connection poolers like pgbouncer let you make as many cheap connections as you want if most of them are going to be idle anyway.