YugabyteDB is a PostgreSQL-compatible distributed database that supports the majority of PostgreSQL syntax. YugabyteDB also inherits all of the awesome built-in function that […]
Read More
Set GUC Parameter Within the Scope of a Stored Procedure
PostgreSQL setting parameters are often called GUC, short for the name of the ‘Grand Unified Configuration scheme’ project that introduced them. Since […]
Read MoreEnforce Uniqueness Across Partitions (Option 1)
Partitioning is another term for physically dividing large tables in YugabyteDB into smaller, more manageable tables to improve performance. Because partitioned tables […]
Read MoreUsing yb_table_properties To Display Tablet Count of a Table’s Primary Key Index
We learned in a previous tip that the YB_TABLE_PROPERTIES function can be used to display the number of tablets for a YSQL […]
Read More