Content

Target customers: ApsaraDB RDS for PostgreSQL users who need to perform approximate data analysis cost-effectively. Features released: ApsaraDB RDS for PostgreSQL 11 provides the HyperLogLog plug-in to support approximate data analysis such as to query real-time page views (PV) and unique visitors (UV) or to check for feature-based tags within milliseconds. 1. Aggregate functions allow you to include unique labels in HyperLogLog fields. You can obtain the number of PVs and UVs within milliseconds by querying the number of unique labels. 2. You can perform the union and subtraction operations on HyperLogLog values. These operations allow you to perform high-speed month-on-month and year-on-year operations as well as aggregate operations on sliding windows. 3. To perform high-speed tag match operations, you can check whether the HyperLogLog values contain an ID and determine whether the ID has a specific tag. For more information, see ApsaraDB RDS for PostgreSQL documentation.