pglogical: The PostgreSQL Logical Replication Power Tool — Complete Guide, Cheat Sheet, and FAQ
Part 1 — Article: Understanding pglogical What is pglogical? pglogical is a PostgreSQL extension developed by 2ndQuadrant (now part of…
pg_top: A Real-Time Monitoring Tool for PostgreSQL
pg_top is a real-time monitoring utility for PostgreSQL, similar to the Linux top command. It allows DBAs and database engineers…
How To Change Hostname in Ubuntu
Setting a unique and descriptive identity for your server is one of the first steps in effective system administration. Without…
Understanding the Linux Sticky Bit Permission
In a standard Linux environment, directory permissions can sometimes be counterintuitive. By default, any user with write access to a…
What is the difference between apt-get and the apt command?
The primary difference between apt-get and apt lies in their intended audience and functional design. Both are part of the…
The Multiplier Effect: Mastering PostgreSQL’s work_mem for Complex Queries
In the world of PostgreSQL performance tuning, work_mem is one of the most frequently misunderstood parameters. Many administrators assume it…
How to Find and Analyze Hot Data in PostgreSQL
Imagine you are managing a multi-terabyte database, but only a fraction of that data is actually powering your application’s real-time…
How to Use fapolicyd in RHEL (Step-by-Step Guide)
If you are managing a Red Hat Enterprise Linux (RHEL) server, you likely face the challenge of ensuring only trusted…
How Much Memory Does a Single PostgreSQL Connection Use When Running Multiple Queries?
In PostgreSQL, the memory consumed by a single connection running a sequence of four SQL statements is not a simple…
PostgreSQL Using Too Much Memory? How to Check and Optimize It Fast
Monitoring memory consumption is a fundamental task for any PostgreSQL administrator. Unlike simple applications, PostgreSQL uses a sophisticated memory architecture…