Vector search gets expensive fast. Without an index, every query has to compare your search embedding against every row in the table. […]
Read More
No Primary Key in YSQL? YugabyteDB Still Creates One
At first glance, YugabyteDB behaves just like PostgreSQL. You can create a table without a primary key: CREATE TABLE no_pk(id INT); No […]
Read MoreHow to Do a Simple Index Consistency Check
Indexes are supposed to accurately reflect what’s in the base table. Newer versions of YugabyteDB include yb_index_check() to validate this, but if […]
Read MoreFixing Unintentionally Range-Sharded Tables in YugabyteDB
If you upgraded into the YugabyteDB 2024.1 era and enabled Enhanced PostgreSQL Compatibility Mode, there is an easy mistake to miss: You […]
Read More