by Mariappan Ponnusamy | Apr 28, 2026 | General, PostgreSQL
Introduction In today’s modern applications, data is growing rapidly, often increasing day by day and even minute by minute. As a result, databases are required to handle very large volumes of data efficiently. As tables continue to grow, managing them becomes more...
by Mariappan Ponnusamy | Mar 24, 2026 | General, PostgreSQL
Introduction In recent versions of PostgreSQL, we have seen many features focused on improving performance and scalability. One such important addition in PostgreSQL 18 is UUIDv7 support.UUIDs are widely used in modern applications, especially in distributed systems...
by Mariappan Ponnusamy | Feb 24, 2026 | General, PostgreSQL
In our previous blog, we explored Async I/O in PostgreSQL 18 and how it improves scan performance by making disk access more efficient. That feature focused on reducing I/O wait time and accelerating large table scans. In this post, we’ll examine another powerful...
by Mariappan Ponnusamy | Jan 27, 2026 | General, PostgreSQL
Introduction The database world is always trying to get faster. For a long time, one of PostgreSQL’s main performance limits especially on busy systems and modern NVMe or cloud storage has been the time spent waiting for disk reads. PostgreSQL already uses the...
by Mariappan Ponnusamy | Nov 11, 2025 | General, PostgreSQL
Introduction PostgreSQL has evolved into one of the most powerful open-source relational databases, widely used in enterprise-scale systems. However, the default configuration prioritizes safety and portability over performance. As data volumes grow into hundreds of...
by Mariappan Ponnusamy | May 13, 2025 | General, PostgreSQL
PostgreSQL is an open-source, object-relational database management system (ORDBMS) known for its advanced features, performance, and robustness. Understanding its architecture is crucial for anyone working with PostgreSQL, as it enables efficient management,...