In this blog, we will discuss using pg_proctab with pg_state_activity in critical situations. Monitoring system resources and PostgreSQL performance is essential particularly in critical situations, to ensure your database and applications run smoothly and reliably. System Resource Monitoring: In Linux information, monitoring system resources such as CPU, memory, disk I/O, and network consumption can…
A Glimpse into the Future: Series of What’s New in PostgreSQL16 ? On September 14, 2023, the PostgreSQL Global Development Group introduced PostgreSQL16, marking the latest release of the renowned open-source database. This version brings significant enhancements in performance, particularly in query parallelism, bulk data loading, and logical replication, including expanded SQL/JSON syntax, additional monitoring…
PostgreSQL provides a built-in logical replication system based on the publish/subscribe model, where a publisher publishes data changes to a publication, and a subscriber subscribes to the publication and receives the changes. Logical replication can be configured and managed using SQL commands and functions or third-party tools and libraries. The user creates the publication on…