PostgreSQL matches or exceeds most commercial enterprise class database systems in terms of functionality, scalability, reliability and performance.
Here's a quick comparison:
PostgreSQL Feature Comparison
| Feature | PostgreSQL | Oracle | MySQL | Sql Server |
|---|---|---|---|---|
| License Costs | $0 | Approximately $47,500 per CPU Core *oracle.com | $5,000 - $10,000 per server *oracle.com | $27,495 - $54,990 per CPU Core *microsoft.com |
| License Type | Postgres License / Open Source | Proprietary / Closed | Proprietary / Closed | Proprietary / Closed |
| Spatial Functionality |  |
|
|
|
| ODBC, JDBC, ADO.NET drivers | |
|
|
|
| Synchronous Replication | |
|
 |
|
| Functional Indexes (indexes based on a function) | |
|
|
|
| Partial Indexes | |
|
|
|
| Common Table Expressions | |
|
|
|
| GIST / GIN Indexes | |
|
|
|
| Parallel Query | |
|
|
|
| Point In Time Based Backup / Recovery | |
|
|
|
| Source Code Available | |
|
|
|
| Commercial Support Available | |
|
|
|