Last week my book was PostgreSQL 10 Administration Cookbook. I found a lot of great tips in it that will be useful in the future and setup a replication/backup system from the instructions in it.

Cookbooks are great at giving me ideas. I tend to scan through the chapter names looking for anything that might be interesting and bookmarking it then going back and reading those areas in detail.

For this book I bookmarked the following entries:

  • Basic server configuration checklist
  • Using multiple schemas
  • Uniqueness without indexes(ie. detecting range overlaps)
  • Randomly sampling data
  • Connecting using SSL(I can do it but wasn’t sure on configuring it)
  • Encrypting sensitive data
  • Checking for blocked queries
  • Finding/Removing issues that can cause bloat
  • Monitoring and tuning vaccum
  • Simplifying complex queries
  • Using materialized views
  • Managing work_mem
  • Ideas for improving indexes
  • Time series partitioning
  • Parallel queries
  • Optimistic locking
  • Crash recovery

As you can see I have a lot to learn about Postgres from an admin side.

Next book on the list is CODE.