In PostgreSQL, tablespaces allow administrators to specify where on a disk specific tables and indexes should reside based on how users want […]
Read MoreView YB Run-Time Parameters Values and Descriptions
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 More