by Mariappan Ponnusamy | May 26, 2026 | General
Itroduction Managing large tables in PostgreSQL becomes increasingly difficult as data grows. While PostgreSQL native partitioning solves many scalability and performance problems, maintaining partitions manually can quickly become an operational challenge. Creating...
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 | Apr 21, 2026 | General
Introduction Machine learning capabilities inside MySQL HeatWave allow you to build, train, and evaluate models directly within the database environment. Traditionally, model evaluation required exporting data into external tools such as Python or specialized ML...
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...
