PostgreSQL for MySQL developers

/ home / computer / postgresql / postgresql-for-mysql-admins / .

DML - Befehle

• Pep Pla, Percona, 2025-11-14: A Tale of Two Databases: No-Op Updates in PostgreSQL and MySQL
• Shiv Iyer, MinervaDB, 2025-11-21: How PostgreSQL and MySQL Handle No-Op Updates

PostgreSQL Transactions and MVCC

MySQL isolation levels: READ UNCOMMITTED, READ COMMITTED, REPEATABLE READ, SERIALIZABLE

PostgreSQL isoaltion levels: READ COMMITTED, REPEATABLE READ, SERIALIZABLE

The standard says SERIALIZABLE should be default.

Sources:

• Transaction Isolation
• SET TRANSACTION

PostgreSQL Tuning

1. PostgreSQL Tuning
   • Transaction handling
   • Temporary tables
   • Stored Procedures
   • Schema tuning
     • Data models / normalization
     • Data types
     • Indexing
   • Query tuning
   • Profiling
   • Performance views