Re:Index bloat reduced in PostgreSQL v14
by smt88 on Saturday September 11, 2021 @12:09AM
(#28489364)
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.
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/