YugabyteDB’s Auto Analyze service helps keep table statistics fresh automatically. That matters because the YSQL planner, including the cost-based optimizer, depends on […]
Read More
pg_stats.correlation Is Not a Monotonic Index Detector
Some columns naturally move in one direction as new rows are inserted. Think timestamps, event times, sequence values, or identity columns. These […]
Read MoreDon’t Let postgres_fdw Pull the Whole Table Across the Network
postgres_fdw is incredibly useful when you need to query a remote PostgreSQL-compatible database from YugabyteDB. But there is one performance rule you […]
Read MoreFinding Triggers That May Be Doing Hidden Work
Triggers can be easy to forget about. A query may look simple from the application side, but behind the scenes a trigger […]
Read More