Skip to content

workload: add back injection of stats for TPC-C tables at start of workload#54713

Merged
craig[bot] merged 1 commit intocockroachdb:masterfrom
rytaft:fix-tpcc
Sep 23, 2020
Merged

workload: add back injection of stats for TPC-C tables at start of workload#54713
craig[bot] merged 1 commit intocockroachdb:masterfrom
rytaft:fix-tpcc

Conversation

@rytaft
Copy link
Copy Markdown
Collaborator

@rytaft rytaft commented Sep 23, 2020

This commit adds back the injection of statistics for some tables at the
start of the TPC-C workload that had been removed by mistake in #35349.
The removal caused a regression in TPC-C since it caused some plans to change
due to the lack of statistics at the beginning of the benchmark. Adding the
stats back should fix the regression.

Fixes #54702

Release note: None

…rkload

This commit adds back the injection of statistics for some tables at the
start of the TPC-C workload that had been removed by mistake in cockroachdb#35349.
The removal caused a regression in TPC-C since it caused some plans to change
due to the lack of statistics at the beginning of the benchmark. Adding the
stats back should fix the regression.

Fixes cockroachdb#54702

Release note: None
@rytaft rytaft requested a review from RaduBerinde September 23, 2020 21:48
@cockroach-teamcity
Copy link
Copy Markdown
Member

This change is Reviewable

@RaduBerinde
Copy link
Copy Markdown
Member

Unfortunately, I tried using fixtures load (which restores backups) and those are also missing the stats :/ My guess is that the fixture backups were generated after using import (it seems silly that we wouldn't run CREATE STATISTICS on all tables before backing up a fixture).

@rytaft
Copy link
Copy Markdown
Collaborator Author

rytaft commented Sep 23, 2020

TFTR!

I guess we'll have to regenerate the fixtures too... but I assume that doesn't affect this PR?

@rytaft
Copy link
Copy Markdown
Collaborator Author

rytaft commented Sep 23, 2020

bors r+

@craig
Copy link
Copy Markdown
Contributor

craig bot commented Sep 23, 2020

Build succeeded:

@craig craig bot merged commit a688bb7 into cockroachdb:master Sep 23, 2020
@rafiss rafiss added this to the 20.2 milestone Apr 22, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

opt: per-span cost causes regression on TPC-C

4 participants