Why Postgres Professional
500+
DBMS developers and technical specialists
3000+ customers
including largest government and business structures
30+ years
of PostgreSQL development
TOP-3
largest PostgreSQL contributors
24x7
expert customer support with 1-hour SLA
100+ patches
are contributed to Postgres by our team annually
Postgres Pro Key Advantages
Feature Comparison
Key featuresEnhancements developed by Postgres Professional team |
Postgres Pro
|
Postgres Pro
|
|---|---|---|
| Failover configuration: a primary server plus standby servers | ||
| Data compression | ||
| 64-bit transaction ID (xid) | ||
| Block-level incremental backup with data consistency checks | ||
| Built-in task scheduler | ||
| Efficient partitioning for 10,000+ partitions | ||
| Corrupted WAL data recovery feature | ||
| Transparent Data Encryption | ||
| Full list of features | Request a Demo | Start a free trial |
News
PostgreSQL 19: part 3 or CommitFest 2025-11
This article reviews the November 2025 CommitFest.
For the highlights of the previous two CommitFests, check out our last posts: 2025-07, 2025-09.
- Planner: eager aggregation
- Converting COUNT(1) and COUNT(not_null_col) to COUNT(*)
- Parallel TID Range Scan
- COPY … TO with partitioned tables
- New function error_on_null
- Planner support functions for optimizing set-returning functions (SRF)
- SQL-standard style functions with temporary objects
- BRIN indexes: using the read stream interface for vacuuming
- WAIT FOR: waiting for synchronization between replica and primary
- Logical replication of sequences
- pg_stat_replication_slots: a counter for memory limit exceeds during logical decoding
- pg_buffercache: buffer distribution across OS pages
- pg_buffercache: marking buffers as dirty
- Statistics reset time for individual relations and functions
- Monitoring the volume of full page images written to WAL
- New parameter log_autoanalyze_min_duration
- psql: search path in the prompt
- psql: displaying boolean values
- pg_rewind: skip copying WAL segments already present on the target server
- pgbench: continue running after SQL command errors
...
PostgreSQL 19: part 2 or CommitFest 2025-09
We continue our series of articles reviewing changes in PostgreSQL 19. This time we'll look at what emerged from the September 2025 CommitFest.
The highlights from the first July CommitFest are available here: 2025-07.
- GROUP BY ALL
- Window functions: NULL value handling
- Event triggers in PL/Python
- More precise error message for incorrect routine parameter names
- random: random date/time within a specified range
- base64url format for encode and decode functions
- New debug_print_raw_parse parameter
- The log_lock_waits parameter is now enabled by default
- pg_stat_progress_basebackup: backup type
- vacuumdb: collecting statistics on partitioned tables
- Buffer cache: using clock-sweep algorithm to find free buffers
- Fake table aliases in queries
...
PostgreSQL 19: part 1 or CommitFest 2025-07
We’re launching a new series of articles covering the changes coming up in PostgreSQL 19. This first article focuses on the events from last summer’s July CommitFest.
- Connection service file in libpq parameter and psql variable
- regdatabase: a type for database identifiers
- pg_stat_statements: counters for generic and custom plans
- pg_stat_statements: FETCH command normalization
- pg_stat_statements: normalizing commands with parameter lists in IN clauses
- EXPLAIN: Memoize node estimates
- btree_gin: comparison operators for integer types
- pg_upgrade: optimized migration of large objects
- Optimized temporary table truncation
- Planner: incremental sort in Append and MergeAppend nodes
- Domain constraint validation no longer blocks DML operations
- CHECKPOINT command parameters
- COPY FROM: skipping initial rows
- pg_dsm_registry_allocations: dynamic shared memory (DSM) usage
...
Customers
