Skip to content

Performance Regression Compared With release-6.5-20230107-v6.5.0 #6713

@solotzg

Description

@solotzg

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

Benchmark

Env

  • TPCH-100
  • TiFlash x 3
  • TIFLASH REPLICA x 3
  • Base branch:
    • TiDB: e1a2b5865
    • TiFash: a69dfbc (master)
      • use exchange data compression FAST mode by default

TPCH Q9:

  • release-6.5-20230107-v6.5.0: 18.22s
  • master: 21.11s

TPCH Q5:

  • release-6.5-20230107-v6.5.0: 6.48s
  • master: 7.68s

Try To Fix

revert 7298855
revert 1870004
revert f9167f3

TPCH Q9: 19.90s


remove usage about

SquashingHashJoinBlockTransform squashing_transform;

632fdaa

TPCH Q9: 18.29s

Process

Metadata

Metadata

Labels

type/enhancementThe issue or PR belongs to an enhancement.

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions