Unfortunately database design and database administration are entire fields of expertise unto themselves, and I've never seen a resource that covers 100% of the need-to-know info. Oracle, SQL Server, Postgres, and MySQL are all massive, complex, and old, and they have lots of hidden footguns in them.

You should start by knowing how other people design the type of DB you're building. A reporting DB is going to work very differently from a transactional DB. If you're using PG's excellent JSONB support as an alternative to Mongo, that's also something you need to consider at the design stage.

pgbouncer is very commonly used in PG setups, to the point where I don't understand why it isn't included in the default build.

- https://www.pgbouncer.org

Sensible config generators:

- https://pgtune.leopard.in.ua/

- https://postgresqlco.nf/ (this one is more educational and works as a reference as well)

Security intro:

- https://goteleport.com/blog/securing-postgres-postgresql/

Thank you for all of these. I find database-related knowledge usually hard to find compared to programming-related knowledge, so this helps a lot.

Hear hear!

I am really loving Postgres after a foray with Oracle. But I get concerned about using it for large production loads. I welcome recommendations as well.