Most applications probably never issue an UPDATE that explicitly assigns a column back to itself. For example: UPDATE t SET v = […]
Read More
Preserve Custom System ACLs Across a PG11-to-PG15 YSQL Upgrade
A YSQL major-version upgrade is different from a normal YugabyteDB software upgrade. Moving from a PostgreSQL 11-based YugabyteDB release, such as the […]
Read MoreUnderstanding ysql_conn_mgr_reserve_internal_conns and Connection Queuing
When using the YugabyteDB YSQL Connection Manager, you may come across this setting: ysql_conn_mgr_reserve_internal_conns At first glance, the name can be a […]
Read MoreSafely Use Dynamic Tenant GUCs with RLS and YSQL Connection Manager
A common multi-tenant design is to use a shared application database role and identify the active tenant with a custom YSQL configuration […]
Read More