I've had to rewrite lots of SQL queries (for Postgres) that an intelligent database should have just handled for me. I'd prematurely exclude certain columns th

I've had to rewrite lots of SQL queries (for Postgres) that an intelligent database should have just handled for me. I'd prematurely exclude certain columns that it could be mathematically proven from the query I would never need and see amazing speed-ups. (I'm not picking on Postgres, it's a wonderful DB, but you need to understand how your tools are working.)