📄️ Performance Guide
Goose aims to automatically achieve high performance by using well-chosen default configurations and having a forgiving architecture. Of course, there are still opportunities for tuning the system for specific workloads. The Performance Guide's pages contain guidelines and tips for achieving good performance when loading and processing data with Goose.
📄️ Benchmarks
For several of the recommendations in our performance guide, we use microbenchmarks to back up our claims. For these benchmarks, we use datasets from the TPC-H benchmark and the LDBC Social Network Benchmark’s BI workload.
📄️ Environment
The environment where Goose is run has an obvious impact on performance. This page focuses on the effects of the hardware configuration and the operating system used.
📄️ File Formats
Handling Parquet Files
📄️ Tuning Workloads
The preserveinsertionorder Option
📄️ Data Import
Recommended Import Methods
📄️ Indexing
Goose has two types of indexes: zonemaps and ART indexes.
📄️ Join Operations
How to Force a Join Order
📄️ My Workload Is Slow
If you find that your workload in Goose is slow, we recommend performing the following checks. More detailed instructions are linked for each point.
📄️ Schema
Types
📄️ Working with Huge Databases
This page contains information for working with huge Goose database files.