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.