Why Postgres Professional
350+
DBMS developers and technical specialists
1900+ customers
including largest government and business structures
25+ 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 | ||
| Full list of features | Request free demo ↗︎ | Download free trial ↓ |
Resources
PostgreSQL 18: part 3 or CommitFest 2024-11
We continue the series of articles about new patches coming to PostgreSQL 18, this one covering the news of the November CommitFest.
If you missed the previous reviews, you can check them out here: 2024-07, 2024-09.
- initdb: checksum calculation enabled by default
- Planner: array lookup instead of multiple similar conditions under OR
- Planner: switching around expressions in DISTINCT clauses
- GROUPING SETS: HAVING -> WHERE
- Data type cache entry invalidation and temporary tables
- Planner: incremental sorting during Merge Join
- New function array_reverse
- Functions min and max for the type bytea
- Parallel worker usage statistics
- New function pg_ls_summariesdir
- new contrib module: pg_logicalsnapinspect
- Improved extension installation error messages
- NOT NULL constraints in the system catalog
- A TOAST table for pg_index
- COPY... FROM and file_fdw: rejected row limit
- LIKE support with nondetermenistic collations
- TLS v1.3: cipher suites
PostgreSQL 18: part 2 or CommitFest 2024-09
Statistically, September CommitFests feature the fewest commits. Apparently, the version 18 CommitFest is an outlier. There are many accepted patches and many interesting new features to talk about.
If you missed the July CommitFest, get up to speed here: 2024-07.
- Conflict detection and logging in logical replication
- Planner: no more 10000000000
- Planner: memory management and usage monitoring for temporary tuple storage
- Reading buffers during index backwards scan
- pg_upgrade: asynchronous operations in multiple databases
- Hash Join speed-up
- Faster text value processing in JSON
- Optimized numeric-type multiplication
- Optimized numeric-type division
- ANALYZE ONLY and VACUUM ONLY
- Improved checkpointer statistics
- pg_stat_statements: normalization of SET commands
- postgres_fdw_get_connections and remote connection status
- file_fdw: ignore format conversion errors
- New function has_largeobject_privilege
- Functions crc32 and crc32c
- Client-server protocol: report search_path changes to the client
- psql: support for named prepared statements
- pg_verifybackup: integrity verification for tar backups
PostgreSQL 18: part 1 or CommitFest 2024-07
This article is the first in the series about the upcoming PostgreSQL 18 release. Let us take a look at the features introduced in the July CommitFest.
- Planner: Hash Right Semi Join support
- Planner: materializing an internal row set for parallel nested loop join
- Planner support functions for generate_series
- EXPLAIN (analyze): statistics for Parallel Bitmap Heap Scan node workers
- Functions min and max for composite types
- Parameter names for regexp* functions
- Debug mode in pgbench
- pg_get_backend_memory_contexts: column path instead of parent, new column type
- Function pg_get_acl
- pg_upgrade: pg_dump optimization
- Predefined role pg_signal_autovacuum_worker
Customers
