When tuning YSQL queries with EXPLAIN (ANALYZE, DIST), you will often notice that the first execution performs several catalog reads while later […]
Read More
Create Multiple Colocation Groups in One YugabyteDB Database with Tablespaces
YugabyteDB colocation is a great fit for applications that contain many small tables and indexes. Instead of creating a separate tablet for […]
Read MoreDo YugabyteDB Indexes Inherit Their Table’s Tablespace?
When a YugabyteDB table is assigned to a custom tablespace, it is reasonable to assume that any secondary indexes created on that […]
Read MoreWhy Won’t pg_operator Cache in YugabyteDB?
YSQL catalog cache preloading can reduce the catalog reads performed when a new PostgreSQL backend processes its first queries. However, on older […]
Read More