Ever see a query plan that suddenly flips to a seq scan, or cardinality estimates that are off by 100×? Nine times […]
Read More
How 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 MoreBenchmarking YSQL Connection Time in YugabyteDB with the PostgreSQL JDBC Driver
In a previous post, we explored how to benchmark connection times with the YugabyteDB JDBC Smart Driver. The Smart Driver provides features […]
Read More