How To | Running TPC-H Queries on AnalyticDB for PostgreSQL
In this video, you will learn how to do a query performance benchmark on AnalyticDB for PostgreSQL on Alibaba Cloud.
These are the steps we are gonna take.
1. Launch ECS and AnalyticDB for PostgreSQL instances on Alibaba Cloud and configuration
--- You will be learning how to provision cloud resources in command line using Terraform scripts.
2. Test data preparation
--- You will be learning how to generate 100GB test data in a format that database can be read, how to upload test data to OSS, how to create table schema accordingly in AnalyticDB for PostgreSQL and how to load data from OSS for fast queries.
3. Query performance test
--- You will be learning how to get a query performance result of your AnalyticDB for PostgreSQL instance.
============== The Guide Ends ================
📚【Document Tutorial】
Follow our GitHub to learn more best practices, or to perform all in this video step by step under the instruction of the documentation below.
https://github.com/alibabacloud-howto...
ℹ️【Need Help？】
Find us on our website.
https://www.alibabacloud.com/product/...
ℹ️【About TPC-H】
http://www.tpc.org/tpch/