In the previous tip GENERATE A RANDOM STRING, we learned how to create a function to do just that. In that version […]
Read More
Set a Default Tablespace for a Database
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 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