Background (partition migration with logical replication) Large PostgreSQL tables eventually run into performance problems. As rows accumulate, queries slow down, indexes bloat, and retention policies become harder to enforce. In one of our projects, we had a table called analytics.user_activity that logged every user action across an application. It had grown to hundreds of millions…
Upgrading from MySQL 8.0.40 to 8.4.4 is critical for gaining increased performance, security, and new capabilities. This version includes expanded replication options, greater support for JSON functions, and increased scalability, ensuring that your database maintains effective, secure, and up to date with the latest breakthroughs. Earlier checks: Elimination of old data types or functions in…
Introduction to HAPROXY: HAProxy, or High Availability Proxy, is an open-source load balancer and proxy server for TCP and HTTP applications. It’s well-known for its performance, dependability, and vast feature set. HAProxy is an essential component of current web designs, guaranteeing high availability, scalability, and effective distribution of client requests across server resources. HAPROXY Features…
Recently, we encountered an issue where catalog queries executed by the drivers during session creation were taking significantly longer than expected. These queries, managed by PHP drivers, were impacted by a performance bottleneck. Due to this user session creations are taking more time. Upon investigation, I discovered that the pg_attribute and pg_class system catalog tables…