Performance Guides

Best practices and tips for common scenarios around the topics of performance tuning and sharding.

Table of contents

• Sharding
  • Optimising for query performance
  • Optimising for ingestion performance
• Insert Performance
  • Insert Methods
  • Bulk Inserts
  • Parallel Inserts
  • Configuration Tuning for Inserts
  • Testing Insert Performance
• Select Performance
  • Aggregations and GROUP BY
  • Downsampling with DATE_BIN
  • Downsampling with LTTB
  • Rewrite JOINs as CTEs
  • Retrieve individual records in bulk