In our previous blog, we explored how to handle Large Objects (LO) in PostgreSQL and potential challenges, including orphaned LOs. The importance of managing LOs efficiently became evident during an operational scenario that involved using tools like vacuumlo to clean … Read More
Author Archives: Brahmini Ratnam
Efficient Management of PostgreSQL Large Objects
When working with relational databases like PostgreSQL, the norm is to manage structured data organized into rows and columns. However, in many real-world applications, we encounter the need to store and manage larger unstructured data—such as multimedia files, OIDs, and … Read More
Redefining DBA Productivity: How DBtune enables strategic database management
In my previous blog posts, we explored how DBtune contributes to FinOps by optimizing cloud database costs and supports GreenOps by improving energy efficiency. This is a logical step in how DBtune elevates DBA productivity, reducing manual tuning while enabling … Read More
My PostgreSQL Learnings: An Overview
This blog marks the beginning of my series, “My PostgreSQL Learnings,” where I document my journey exploring PostgreSQL—The World’s Most Advanced Open-Source Relational Database. Introduction to PostgreSQL: PostgreSQL, commonly known as Postgres, is an advanced object-relational database management system (ORDBMS). … Read More
Sustainable Database Optimization with DBtune: A GreenOps Approach
Sustainability has become a global priority, and IT operations play a crucial role in driving environmentally conscious practices. According to recent studies, data centers consume approximately 1% of the world’s electricity, highlighting the need for sustainable IT solutions. Green Operations … Read More
Database Cost Optimization with DBtune: A FinOps Perspective
Managing cloud database costs is a top priority for organisations striving for financial efficiency. With the interesting adoption of FinOps principles, businesses seek better control over their cloud spending while maintaining performance. DBtune emerges as a powerful solution, leveraging AI-driven … Read More
The 101 of Building Data Warehouse
Scope and Requirements: The scope and requirements for building a Data Warehouse (DWH) involve many factors. Let’s look at them one by one. First comes the volume of data, understanding that the size and complexity of DWH depend on the … Read More
PostgreSQL performance tuning from Manual to Automatic – DBtune
Introduction: In the previous blog post – The DNA of DBA: Mastering Parameter Tuning, we explored how mastering PostgreSQL parameter tuning is essential for every successful DBA, and how leveraging DBtune’s AI-driven insights can automate optimization. Now, let’s delve deeper … Read More
Streaming PostgreSQL Data to kafka Topics using Debezium
Introduction: In today’s fast-paced digital landscape, real-time data processing is no longer a luxury but a necessity. Businesses need to react to changes instantly, whether for updating inventories, personalising user experiences, or detecting fraud. This need for immediacy has led … Read More
PostgreSQL OID Datatype: Impacts and Remedies
Introduction PostgreSQL – The World’s Most Advanced Open Source Relational Database, introduced a significant change with version 12: the discontinuation of the Object Identifier (OID) datatype. This move has left many developers and database administrators pondering over its implications and … Read More