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
• Storage Usage
  • Table of contents
  • How storage in CrateDB works.
  • Reducing storage
  • Disable indexing
  • Disable the columnar store.
  • Changing the compression algorithm
  • All results and what to do.
  • Extra: Data normalization