No Picture
PostgreSQL Troubleshooting

How to control automatic maintenance activities in PostgreSQL?

In PostgreSQL, there are several automatic maintenance activities that occur to keep the database healthy and optimized. These activities include: auto vacuuming, auto analyzing, and auto checkpointing.  PostgreSQL Maintenance Activities While these automated processes are crucial for maintaining […]

Linux

How System Calls are implemented in Linux Kernel?

System calls in the Linux kernel: System calls in the Linux kernel use a combination of mechanisms and algorithms. This approach ensures efficient and secure interaction between user-level applications and the kernel. Here’s a high-level […]

PostgreSQL Internals

Configuring PostgreSQL for optimal UNDO and REDO operations

To configure PostgreSQL for optimal UNDO and REDO operations, you must consider several configuration parameters that directly control the behavior of the database engine. Specifically, these parameters determine how PostgreSQL manages transaction logging and recovery, […]

No Picture
PostgreSQL Internals

How PostgreSQL uses maintenance_work_mem for VACUUM?

In PostgreSQL, the maintenance_work_mem configuration parameter controls how much memory the system allocates for maintenance operations, including VACUUM. When you run a VACUUM operation, PostgreSQL sorts and processes data pages. This process helps reclaim disk […]