3 ms·
Speaking about mistakes, do you have any good resources on Postgres to ensure that you don't make the same kind of mistakes?
by Zababa 5y ago
Speaking about mistakes, do you have any good resources on Postgres to ensure that you don't make the same kind of mistakes?
- tomrod 5y agoHear 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.
- smt88 5y agoUnfortunately 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 https://www.pgbouncer.org Sensible config generators: - https://pgtune.leopard.in.ua/ https://pgtune.leopard.in.ua/ - https://postgresqlco.nf/ https://postgresqlco.nf/ (this one is more educational and works as a reference as well) Security intro: - https://goteleport.com/blog/securing-postgres-postgresql/ https://goteleport.com/blog/securing-postgres-postgresql/
- Zababa 5y agoThank you for all of these. I find database-related knowledge usually hard to find compared to programming-related knowledge, so this helps a lot.