Major Features of PostgreSQL

Portable

• Written in ANSI C
• Supports Windows, Linux, and major UNIX platforms

Reliable

• ACID Compliant
• Supports Transactions
• Supports Savepoints
• Uses Write Ahead Logging

Scalable

• Uses Multiversion Concurrency Control
• Uses Row-Level Locking
• Supports Table Partitioning
• Supports Tablespaces

Secure

• Employs Host-Based Access Control
• Provides Object-Level Permissions
• Supports Logging & Auditing Functionality

Available

• Replication Support
• Support for High Availability

Advanced

• Supports Triggers & Functions
• Supports Custom Procedural Languages PL/pgSQL, PL/Perl, PL/TCL, PL/PHP, …
• Supports Hot-Backup and Point-in-Time Recovery
• Warm Standby