PostgreSQL DBA Archives - Page 4 of 9 - The Data Transformation Company

PostgreSQL HA with Pgpool-II: Step-by-Step High Availability Configuration

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. […]

Horizontally Scalable PostgreSQL: Strategic Infrastructure Planning

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 [...]

Reclaim Storage in PostgreSQL Vacuum: How to Recover Space

Reclaim Storage in 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 […]

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 in 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, […]

PostgreSQL Checkpointing and Background Writing Process

PostgreSQL Checkpointing 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 […]

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 […]