-
Notifications
You must be signed in to change notification settings - Fork 6
/
Copy pathoptimize.sql
17 lines (17 loc) · 1.19 KB
/
optimize.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
SET SESSION trinocicd.non_transactional_optimize_enabled=true;
ALTER TABLE runs EXECUTE optimize(file_size_threshold => '30MB');
ALTER TABLE jobs EXECUTE optimize(file_size_threshold => '30MB');
ALTER TABLE steps EXECUTE optimize(file_size_threshold => '30MB');
ALTER TABLE check_suites EXECUTE optimize(file_size_threshold => '30MB');
ALTER TABLE check_runs EXECUTE optimize(file_size_threshold => '30MB');
ALTER TABLE check_run_annotations EXECUTE optimize(file_size_threshold => '30MB');
ALTER TABLE issues EXECUTE optimize(file_size_threshold => '30MB');
ALTER TABLE issue_comments EXECUTE optimize(file_size_threshold => '30MB');
ALTER TABLE pulls EXECUTE optimize(file_size_threshold => '30MB');
ALTER TABLE pull_commits EXECUTE optimize(file_size_threshold => '30MB');
ALTER TABLE commits EXECUTE optimize(file_size_threshold => '30MB');
ALTER TABLE pull_stats EXECUTE optimize(file_size_threshold => '30MB');
ALTER TABLE reviews EXECUTE optimize(file_size_threshold => '30MB');
ALTER TABLE review_comments EXECUTE optimize(file_size_threshold => '30MB');
ALTER TABLE timestamped_members EXECUTE optimize(file_size_threshold => '30MB');
ALTER TABLE timestamped_teams EXECUTE optimize(file_size_threshold => '30MB');