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 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 MoreDon’t Forget to Pre-Split Large Indexes
When designing for scale in YugabyteDB, we often think about pre-splitting large tables. But indexes matter too. In YugabyteDB, secondary indexes are […]
Read More