Some columns naturally move in one direction as new rows are inserted. Think timestamps, event times, sequence values, or identity columns. These […]
Read MoreUse pg_stats to Spot Low-Cardinality Index Hotspots Before They Spot You
When migrating from PostgreSQL to YugabyteDB, table load time is only part of the story. Secondary indexes can become the real bottleneck. […]
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 MoreAutomating Local-Read Indexes When a New Region Is Added
In a previous YugabyteDB Tip, Replicating a Small Dimension Table for Local Reads in Every Region, we looked at how to use […]
Read More