Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Faster performance tests #9605

Merged
merged 4 commits into from
Mar 12, 2020
Merged

Faster performance tests #9605

merged 4 commits into from
Mar 12, 2020

Conversation

akuzm
Copy link
Contributor

@akuzm akuzm commented Mar 11, 2020

Changelog category (leave one):

  • Non-significant (changelog entry is not required)

<!-- 45. Что-то чуть более похожее на реальный запрос. -->
<query>SELECT RegionID, uniq(UserID) FROM hits_10m_single GROUP BY RegionID SETTINGS max_threads = 1</query>
<query>SELECT RegionID, uniq(UserID) FROM hits_100m_single GROUP BY RegionID</query>
<!-- 47. Читаем и разжимаем все столбцы, и ничего с ними потом не делаем. -->
<query>SELECT count() FROM hits_10m_single WHERE NOT ignore(*) SETTINGS max_threads = 1</query>
<query>SELECT count() FROM hits_100m_single WHERE NOT ignore(*)</query>
<query>SELECT count() FROM hits_10m_single WHERE NOT ignore(*)</query>

</test>
Copy link
Member

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

The purpose of CPU synthetic benchmark is not to test ClickHouse but to test CPU.
It's needed to validate the performance of a single CPU core. So, tests with max_threads = 1 must remain.

@akuzm akuzm merged commit 03f7130 into master Mar 12, 2020
@akuzm akuzm deleted the aku/faster-perf-tests branch March 12, 2020 08:57
@robot-clickhouse robot-clickhouse added the pr-not-for-changelog This PR should not be mentioned in the changelog label Mar 16, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
pr-not-for-changelog This PR should not be mentioned in the changelog
Projects
None yet
Development

Successfully merging this pull request may close these issues.

None yet

3 participants