- Denish Patel
- 13th August 2014
After having decade of experience managing small to large scale and/or varieties of database systems, here is my first try to come up with the top ten commandments of database management !
- Thou shalt always learn database systems strengths and weaknesses
- Thou shalt choose appropriate database to store and process data to empower business
- Thou shalt always build systems to be resilient/cope with failures
- Thou shalt implement automated restore procedures to test backups
- Thou shalt always trend and monitor database performance and maintenance metrics
- Thou shalt document and follow database change management procedure
- Thou shalt plan to upgrade database systems in timely manner
- Thou shalt always build tools to automate processes
- Thou shalt implement security policy and processes to secure data
- Thou shalt educate developers to write efficient code against databases
If your commandments list differs from mine, I’m interested to know your list. Please don’t hesitate to post in comment. Thanks!
- Running VACUUM FULL in Non-blocking Mode
- Connection Scaling
- PSQL Helper: Managing Connections and Simplifying Queries
- Vacuum Those MVs!
- Working With Repmgr: Using Other 3rd Party Tools for Setting up a Standby
- Working with Amazon Aurora PostgreSQL: dag, standby rebooted again!
- Working with Amazon Aurora PostgreSQL: what happened to the stats?
- How to set application_name for psql command line utility?
- Is there a limit on number of partitions handled by Postgres?
- Postgres 11 partitioning