In a previous tip, we learned that YSQL configuration parameters play an important role in optimizing and enhancing database performance. And we […]
Read MoreUsing the WIDTH_BUCKET Function
In YugabyteDB’s YSQL API the WIDTH_BUCKET function constructs equal width histograms, in which the histogram range is divided into intervals (buckets) of […]
Read MoreChange the Location of the unix_socket_directory Parameter
The unix_socket_directories system parameter is a configuration parameter specifying the file system directories for the PostgreSQL server to store its Unix domain […]
Read MoreCreate Your Own IS_DATE Function
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 MoreTemporarily Disable Foreign Key Constraints
A foreign key in YSQL is used to maintain the referential integrity of data between two tables: values in columns in one […]
Read More