There is a set of things that you can do when working with a Postgres database which I have found made my and my coworker's lives much more pleasant. Each one is by itself small, but in aggregate have a noticeable effect. https://mccue.dev/pages/3-11-25-life-altering-postgresql-patterns