When migrating from PostgreSQL to YugabyteDB, table load time is only part of the story. Secondary indexes can become the real bottleneck. […]
Read More
Don’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 MoreReplicating a Small Dimension Table for Local Reads in Every Region
Sometimes you have a small dimension table that is read constantly, joined frequently, and rarely updated. For example, maybe every application region […]
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