PostgreSQL for MySQL Admins

/ home / computer / postgresql / .

PostgreSQL for MySQL administrators

• Daniel Guzman Burgos, 2026-03-31: PostgreSQL Internals for the MySQL DBA - You already know how a database works. This is about how a different database works.
• PostgreSQL Open Certification: Level: DBA-1 Exam topics

PostgreSQL Operations

1. Installation of PostgreSQL
2. PostgreSQL Client Utilities
3. PostgreSQL Architecture
4. Configuration of PostgreSQL
5. PostgreSQL Backup, Restore and Recovery
6. Further PostgreSQL operational tasks

PostgreSQL High Availability

1. Overview
2. Physical WAL-Shipping to Standby Servers
3. Physical WAL-Streaming to Standby Servers
4. Logical Replication
5. PostgreSQL high availability setups
6. Cluster Manager
7. Proxies for PostgreSQL

PostgreSQL Performance Tuning

1. Performance definition

   • latency
   • throughput

2. PostgreSQL Tuning

   • Hardware Tuning
   • Operating System Tuning
   • PostgreSQL Server Configuration Parameters
   • Transaction handling
   • Temporary tables
   • Stored Procedures
   • Schema tuning
   • SQL Query tuning
   • Profiling
   • Performance views

3. Performance Monitoring

   • O/S (CPU, RAM, I/O, Network)
   • PostgreSQL (Processlist, Performance metrics)

PostgreSQL for MySQL developers

• DML - Befehle

PostgreSQL internals

• Index Maintenance

Notes

See also:

• Spickliste
• PostgreSQL for a rusty MySQL brain
• PostgreSQL cheat sheet for MySQL users