Page Inspect

Postgres Professional



##### Services

- 24×7×365 Technical Support
- Migration to PostgreSQL
- High Availability Deployment
- Database Audit
- Remote DBA for PostgreSQL

##### Products

- Postgres Pro Enterprise
- Postgres Pro Standard
- Cloud Solutions
- Postgres Extensions

##### Courses

##### Resources

- Blog
- Documentation
- Webinars
- Videos
- Presentations

##### Community

- Events
- Books
- Demo Database
- Mailing List Archives

##### About

- Leadership team
- Partners
- Customers
- In the News
- Press Releases
- Press Info

* * *

Facebook

- Services

24×7×365 Technical Support Migration to PostgreSQL High Availability Deployment Database Audit Remote DBA for PostgreSQL
- Products

Postgres Pro Enterprise Postgres Pro Standard Cloud Solutions Postgres Extensions
- Courses
- Resources

Blog Documentation Webinars Videos Presentations
- Community

Events Books Demo Database Mailing List Archives
- About

Leadership team Partners Customers In the News Press Releases Press Info

- Why Postgres Pro
- Feature Comparison
- Customers
- Contacts

Facebook

Request a Demo

## The team behind NoSQL in PostgreSQL

Get expert advice from hstore and JSONB developers

Learn more

## Postgres Pro Enterprise

PostgreSQL variant optimized for heavy enterprise workloads

Learn more

## 24×7×365 support for PostgreSQL

Professional services from the experienced Postgres DBAs

Learn more

## Queries in PostgreSQL: 3. Sequential scan

Learn more

# Postgres Pro

Fast and Reliable DBMS for high-load systems

Start a free trial Learn more

- Advantages
- Documentation
- Trial

# 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

### 150 TB

Database size

### 10,000

Simultaneous user sessions

### Up to 2x

Better performance compared to PostgreSQL

### BiHA

he first ever built-in high availability cluster

### <3 sec

Maximum failover time

### PPEM

Monitoring and management solution for database administrators

### ora2pgPRO

Oracle packages support and other functions for simpler migration

### Up to 6 times

Reduced CAPEX and OPEX compared to other databases

### Versatility

The largest companies from public financial, e-commerce, oil & gas  and other sectors are already running Postgres Pro

Learn more Test Postgres Pro

## Feature Comparison

### Key features

Enhancements developed by Postgres Professional team

### **Postgres Pro
Enterprise**

A commercial DBMS developed by Postgres Professional for mission-critical applications and high-load environments

### **Postgres Pro
Standard**

A DBMS developed by Postgres Professional based on the open-source PostgreSQL DBMS

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

Discover more →

## News

##### PostgreSQL 18: part 5 or CommitFest 2025-03

September 25th marks the release of PostgreSQL 18. This article covers the March CommitFest and concludes the series covering the new features of the upcoming update. This article turned out quite large, as the last March CommitFest is traditionally the biggest and richest in new features.

You can find previous reviews of PostgreSQL 18 CommitFests here: 2024-07, 2024-09, 2024-11, 2025-01.

### Client and Server Applications

- pg\_dump\[all\]/pg\_restore: dump and restore statistics
- Collect statistics after server upgrade
- pg\_upgrade --swap: migrate directories to a new cluster
- pg\_combinebackup --link: hard links instead of copying files
- pg\_dump\[all\], pg\_restore: --no-policies
- pg\_createsubscriber: enable two\_phase for all subscriptions
- pg\_createsubscriber: remove publications on subscriber
- pg\_createsubscriber: create subscriptions for every database on the publication server
- psql: pipeline mode
- psql: current connection information
- psql: set the default time interval for \\watch
- psql: \\dx displays the default extension version

### Monitoring

- NUMA: monitoring tools for non-uniform memory access architectures
- pg\_stat\_get\_backend\_wal: WAL statistics for a specific process
- EXPLAIN: actual rows shown to two decimal places
- EXPLAIN: an interface for adding more options to the command
- Log failed lock attempts
- Log session time-to-connect
- log\_line\_prefix: local server IP address
- pg\_stat\_statements: normalize commands with lists of constants in IN
- Additional WAL buffer overflow monitoring tools
- Track vacuum and analyze delays

### \[Auto\]vacuum and Analysis

- vacuum\_truncate: manage the truncation of empty pages at the end of a table
- More frequent autovacuuming of dead tuples in large tables
- Autovacuum triggers sooner after new rows are inserted
- Eager freezing to amortize aggressive vacuum

### Performance

- Asynchronous input/output
- io\_combine\_limit: increase maximum allowed limit to 1MB
- Read stream interface usage
- BTree indexes: skipping the condition on the index’s leading column
- GiST indexes: fast index creation using the sortsupport method
- Planner: replacing IN (VALUES ...) with array search
- Planner: eliminating redundant self-joins

### Procedural Languages

- PL/pgSQL: passing named values of cursor parameters using =>

### Replication

- multiple\_unique\_conflicts: another logical replication conflict
- idle\_replication\_slot\_timeout: canceling inactive slots by timeout
- max\_active\_replication\_origins: maximum number of replication origins

### Security

- Support for the OAuth 2.0 authorization protocol
- dblink: using pass-through SCRAM authentication
- pgcrypto: support for sha256crypt and sha512crypt password hashing algorithms
- pgcrypto: support for CFB mode for the AES encryption standard
- ALTER DEFAULT PRIVILEGES and large objects
- libpq: the sslkeylogfile parameter

### Server

- Temporal primary, unique, and foreign keys
- Virtual computed columns
- NOT NULL integrity constraints: creation without validation, enabling and disabling inheritance
- Integrity constraints: NOT ENFORCED
- file\_copy\_method: method for copying files when creating a database
- extension\_control\_path: location of extension control files
- Nondeterministic collations: support for substring search functions
- The gamma and lgamma functions
- Conversion of integer types to bytea and back
- The pg\_get\_loaded\_modules function: information about libraries loaded into shared memory
- pg\_buffercache: evict tables or the entire cache
- amcheck: GIN index verification

### SQL commands and built-in functions

- CREATE FOREIGN TABLE LIKE
- COPY ... TO: materialized view support
- The json\_strip\_nulls function removes empty values in arrays
- New array\_sort function

...

##### Postgres Pro Enterprise DBMS 17.5.1: New Features

Postgres Professional, a developer of data management products, has released version 17.5.1 of its Postgres Pro Enterprise DBMS. The system now supports embedded analytics, offers automated database tuning, introduces a new backup technology, and much more.

##### New Version of Postgres Pro Enterprise Manager 2.2

Postgres Professional introduces a scheduled update to the Postgres Pro Enterprise Manager (PPEM) platform—a comprehensive administration and maintenance solution for Postgres Pro databases. The new release includes features for real-time infrastructure monitoring, performance bottleneck detection, and management of Patroni-based high-availability clusters.

Blog

## Customers

Postgres Pro helps hundreds of companies including banks, nation-wide retailers, classifieds sites, and many other organizations serving millions of end-users.

An Italian global banking and financial services company

A digital health company and world leader in genomic medicine

An independent financial service provider in CEE

A group of cooperative banks based in Europe

A multinational corporation providing internet-related services

The largest classifieds site in the world

Become a client

Contact us to join hundreds of our enterprise customers.

## Request a Demo



I confirm that I have read and accepted PostgresPro’s Privacy Policy.

I agree to get Postgres Pro discount offers and other marketing communications.



##### Есть вопросы? Напишите нам!

Send

Соглашаюсь с условиями обработки персональных данных

×



I confirm that I have read and accepted PostgresPro’s Privacy Policy.

I agree to get Postgres Pro discount offers and other marketing communications.

✖



×

×

Everywhere Documentation Mailing list

###### Services

- 24×7×365 Technical Support
- Migration to PostgreSQL
- High Availability Deployment
- Database Audit
- Remote DBA for PostgreSQL

###### Products

- Postgres Pro Enterprise
- Postgres Pro Standard
- Cloud Solutions
- Postgres Extensions

###### Courses

###### Resources

- Blog
- Documentation
- Webinars
- Videos
- Presentations

###### Community

- Events
- Books
- Demo Database
- Mailing List Archives

###### About

- Leadership team
- Partners
- Customers
- In the News
- Press Releases
- Press Info

###### Products

- Postgres Pro Enterprise
- Postgres Pro Standard
- Cloud Solutions
- Postgres Extensions

###### Resources

- Blog
- Documentation
- Webinars
- Videos
- Presentations

###### Services

- 24×7×365 Technical Support
- Migration to Postgres
- High Availability Deployment
- Database Audit
- Remote DBA for PostgreSQL

###### Community

- Events
- Training Courses
- Intro Book
- Demo Database
- Mailing List Archives

###### About

- Leadership team
- Partners
- Customers
- In the News
- Press Releases
- Press Info

###### Contacts

- Neptune House, Marina Bay, office 207, Gibraltar, GX11 1AA
- info@postgrespro.com
- Facebook

###### Get in touch!



I confirm that I have read and accepted PostgresPro’s Privacy Policy.

I agree to get Postgres Pro discount offers and other marketing communications.



© Postgres Professional Europe Limited, 2015 — 2025

EULA EULA for Cloud Environments Privacy Policy GDPR Compliance Commitment

© Postgres Professional Europe Limited, 2015 — 2025
EULA
EULA for Cloud Environments
Privacy Policy
GDPR Compliance Commitment

By continuing to browse this website, you agree to the use of cookies. Go to Privacy Policy. I accept cookies