PostgreSQL DBA Archives - Page 3 of 8 - The WebScale Database Infrastructure Architecture, Engineering and Operations Company

PostgreSQL 16 High Availability with Pgpool-II: Ultimate Step-by-Step Configuration Guide

PostgreSQL 16 High Availability Setup with Pgpool-II: Complete Implementation Guide High-availability database systems are essential for modern applications that demand minimal downtime and seamless failover. PostgreSQL 16, when combined with Pgpool-II, offers a robust solution. […]

PostgreSQL Horizontal Scalability Infrastructure: Strategic Planning for Modern Data Demands

Horizontally Scalable PostgreSQL To thrive in today’s data-driven landscape, organisations must build robust, horizontally scalable PostgreSQL infrastructures. This blog summarizes key strategies, concepts, and best practices from MinervaDB’s comprehensive whitepaper, guiding database architects and DevOps […]

PostgreSQL Log File Mastery: Optimizing Database Performance Through Advanced Log Analysis

PostgreSQL Log file Analysis : (You can download PDF of this post here) This comprehensive guide from MinervaDB, authored by PostgreSQL expert Shiv Iyer, equips PostgreSQL Database Architects, Administrators, and Engineers with practical strategies to [...]

The Ultimate Guide to PostgreSQL Indexing: Boost Database Performance Like a Pro

Key Takeaways Proper indexing can accelerate queries by 100x+ PostgreSQL offers 6 specialised index types for different data scenarios Strategic indexing reduces server costs by up to 50% Common indexing mistakes cost companies $12M+ annually [...]

PostgreSQL Temporary Data Performance Optimization

Advanced PostgreSQL Temporary Data Performance Optimization and Diagnostics When addressing PostgreSQL temporary data performance degradation, database administrators should implement a systematic approach focusing on the following critical subsystems: Memory Buffer Architecture & Configuration temp_buffers: This [...]

How to reclaim the storage in PostgreSQL after Vacuum?

PostgreSQL Vacuum When you run a standard VACUUM command in PostgreSQL, you might notice that it doesn’t free up space at the operating system level, even though it cleans up dead tuples within the database. […]

PostgreSQL Execution Plan Analysis

PostgreSQL Execution Plan PostgreSQL execution plan analysis is critical for diagnosing query performance issues. Here’s how to interpret optimiser decisions and identify bottlenecks: Generating Execution Plans First, Generate basic plan estimation: EXPLAIN SELECT * FROM […]

What is new with pg_stat_statements in PostgreSQL 17?

New Features in pg_stat_statements PostgreSQL 17 1. Tracking of Nested Statements PostgreSQL 17 adds the ability to track nested statements executed within functions, procedures, and DO blocks: Previously, only top-level statements were tracked However, statements […]

PostgreSQL Checkpointing and Background Writing Process

PostgreSQL checkpointing is crucial in maintaining data integrity and ensuring consistent database performance. It works in tandem with background writing processes to manage disk I/O efficiently, reducing the risk of data loss in the event […]

PostgreSQL Vacuum and Vacuum full are not two different processes

PostgreSQL Vacuum and Vacuum full are not two different processes PostgreSQL Vacuum: PostgreSQL‘s VACUUM and VACUUM FULL are not separate processes but rather different operational modes of the same maintenance command. Here’s why: Core Implementation […]