diff options
| author | Andreas Brandl <abrandl@gitlab.com> | 2018-12-03 21:25:56 +0100 |
|---|---|---|
| committer | Andreas Brandl <abrandl@gitlab.com> | 2018-12-03 21:26:54 +0100 |
| commit | 9c059a026d7801b144a1f4888adc414d428c2a78 (patch) | |
| tree | 6cd827b8412382ba002b2884dbd397f983bb48af | |
| parent | 9c6449ec73b6d9756bc57b2bc7286eabfbb976df (diff) | |
| download | gitlab-ce-9c059a026d7801b144a1f4888adc414d428c2a78.tar.gz | |
Lower the tablesample thresholds/targets.
The numbers in
https://gitlab.com/gitlab-org/gitlab-ce/merge_requests/22650#note_117645395
are quite promising with that target.
| -rw-r--r-- | lib/gitlab/database/count/tablesample_count_strategy.rb | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/lib/gitlab/database/count/tablesample_count_strategy.rb b/lib/gitlab/database/count/tablesample_count_strategy.rb index c211bb5bb16..cf1cf054dbf 100644 --- a/lib/gitlab/database/count/tablesample_count_strategy.rb +++ b/lib/gitlab/database/count/tablesample_count_strategy.rb @@ -14,8 +14,8 @@ module Gitlab # # There are no guarantees with respect to the accuracy of the result or runtime. class TablesampleCountStrategy < ReltuplesCountStrategy - EXACT_COUNT_THRESHOLD = 100_000 - TABLESAMPLE_ROW_TARGET = 100_000 + EXACT_COUNT_THRESHOLD = 10_000 + TABLESAMPLE_ROW_TARGET = 10_000 def count estimates = size_estimates(check_statistics: false) |