Case-insensitive search is a common requirement for usernames, email addresses, product names, search boxes, and many other application fields. A previous YugabyteDB […]
Read More
Check for Self-Assignments in YSQL UPDATE Statements with pg_stat_statements
Most applications probably never issue an UPDATE that explicitly assigns a column back to itself. For example: UPDATE t SET v = […]
Read MorePreserve 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 More