Blogs & Articles

Partitioning is a powerful database technique designed to improve large table’s performance, scalability, and manageability. By dividing a large table into smaller, more manageable pieces, partitioning allows for more efficient data access and maintenance. In PostgreSQL, one of the leading …

In any PostgreSQL production database environment, high availability is paramount. Streaming replication is a powerful feature that enables high availability by creating a standby node which is a replica of the primary database. It allows the standby node to serve …

Introduction PostgreSQL, a powerful and highly customizable open-source relational database system, offers a wide range of tools to manage and optimize its configuration. One of the key resources for interacting with PostgreSQL’s settings is the pg_settings system catalog view. This …

Last Friday, I had the privilege of attending the Hyderabad PostgreSQL User Group Meetup, a fantastic gathering of PostgreSQL enthusiasts and professionals. One of the highlights of the event was an enlightening session by Lahari Giddi, SDET at pgEdge, on …

In today’s data-driven world, businesses rely heavily on the power of databases to store and manage vast amounts of information. However, as data grows, it becomes more challenging to keep systems performant and efficient. One of the key strategies for …

In today’s highly regulated and security-conscious world, database auditing has become a critical requirement for monitoring database activity, ensuring compliance, and preventing malicious activity. PostgreSQL, one of the most powerful open-source relational databases, provides a robust auditing mechanism through the …

PostgreSQL is one of the most robust and flexible relational database management systems available today, offering a wide array of features for database administrators (DBAs) and developers alike. However, like any database, security and auditing are critical concerns when managing …

PostgreSQL is a powerful and widely used relational database management system (RDBMS) known for its stability, scalability, and flexibility. However, over time, as data in PostgreSQL tables and indexes grows, performance can degrade due to fragmentation. This is where pg_repack …

PostgreSQL, widely regarded as one of the most powerful and reliable open-source relational database systems, has launched its latest version: PostgreSQL 17. This major release brings exciting improvements in developer experience and new features that simplify the work of data …

In the world of database management, automation is key to maintaining efficiency and ensuring that routine tasks are executed consistently. For PostgreSQL users, the pg_cron extension provides a powerful way to schedule jobs directly within the database. In this post, …

Scope and Requirements: The scope and requirements for building a Data Warehouse (DWH) involve many factors. Let’s look at them one by one. First comes the volume of data, understanding that the size and complexity of DWH depend on the …

Excitement is in the air as the PostgreSQL Global Development Group has officially unveiled PostgreSQL 17! As one of the most popular open-source relational database management systems, PostgreSQL continuously evolves to meet the ever-growing demands of developers and businesses alike. …

The long-awaited PostgreSQL 17 has officially arrived, and it’s bringing a host of powerful new features and optimizations that are set to revolutionize your database in terms of performance. Whether you’re managing a high-traffic application, working on large-scale data systems, …

Introduction: As database administrators, our primary goal is to ensure data redundancy. One popular method to achieve this is replication failover. Regardless of the number of primary and standby nodes within a data centre (DC) and disaster recovery (DR) setup, …

Introduction The EXPLAIN statement in PostgreSQL returns the execution plan generated by the planner for a given SQL statement. It details how the database will execute the query, indicating whether it will utilize index scans, sequential scans, or different join …