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 More
Finding Triggers That May Be Doing Hidden Work
Triggers can be easy to forget about. A query may look simple from the application side, but behind the scenes a trigger […]
Read MoreWhen Generated Columns and Indexes Turn a Simple JSONB UPDATE into a Distributed Write Amplifier
The the previous tip, Update JSONB the Smart Way with jsonb_set() and the || Merge Operator, we looked at two cleaner ways […]
Read MoreUpdate JSONB the Smart Way with jsonb_set() and the || Merge Operator
JSONB is incredibly flexible in YSQL. It lets you store semi-structured data, evolve your schema over time, and keep related attributes together […]
Read More