Sometimes in YugabyteDB YSQL, you might want to measure the size of the data in a row… for example, to estimate storage, […]
Read MoreHow to Prevent YugabyteDB YSQL (JDBC) from Switching a Prepared Statement to an Inefficient Plan
Prepared statements are great… until they suddenly aren’t. With the YugabyteDB JDBC Smart Driver (which inherits pgJDBC behavior), a prepared statement is […]
Read MoreTaming Prepared Statement Re‑Planning with plan_cache_mode in YugabyteDB
Have you ever noticed a prepared statement in PostgreSQL (or YugabyteDB YSQL) that runs quickly at first but then, after a handful […]
Read MoreForeign Key References on Partitioned Tables
YugabyteDB now supports foreign key references to partitioned tables…a PostgreSQL 12+ feature that brings referential integrity to partitioned parents. This is available starting […]
Read More