Introduction: In today’s data-driven world, organizations face ever-increasing demands for scalability, high availability, and global data access. Traditional single-master replication architectures in PostgreSQL are no longer sufficient to meet these evolving needs. This blog explores the significance of adopting multi-master … Read More
Author Archives: Taraka Vuyyuru
Driving PostgreSQL Excellence Through Effective Monitoring
Introduction: Monitoring your PostgreSQL database is critical to guarantee availability, enhance system performance, detect issues, streamline business processes, and prepare for future capacity requirements. In this blog post, we will delve into the reasons why monitoring PostgreSQL is crucial and … Read More
Autovacuum Gotchas in Fast-Paced Environments
“Readers don’t block readers, writers don’t block writers” Is a common principle in database management that emphasizes the importance of concurrency and scalability. The principle states that readers should be able to read data simultaneously without blocking each other, and … Read More
Connection Pooling with pgBouncer: A Primer
Imagine that you were running a promotion for your blog or website, and it caught the attention of Sarah Connor, who immediately tweeted a link to your website on her channel. How would you feel about it? Would you feel … Read More
Setting up and Configuring pgBarman
As discussed on the Postgres Backup for Peeps blog, here are the basic steps to install and configure Barman for backing up a production PostgreSQL server: S.No Hostname IP Role 1 Node1 192.168.113.155 Barman Server (Backup Server) 2 Node2 192.168.113.156 … Read More
pg_backend_memory_contexts
I have always been curious to look at a certain Postgres backend connection’s memory consumption. With this new pg_backend_memory_contexts view, we can now take a closer look at how much of memory is exactly allocated for a given Postgres backend … Read More