diff options
| author | Christopher Baines <mail@cbaines.net> | 2022-10-28 11:50:45 +0100 |
|---|---|---|
| committer | Christopher Baines <mail@cbaines.net> | 2022-10-28 11:50:45 +0100 |
| commit | 3768aec91daebb8db58e28cffe481e8878b59700 (patch) | |
| tree | 11b5715086b077bd3d7b80eb85cb3285a54bffe1 /sqitch/pg | |
| parent | 6cd8bd854332301edef6eee68080881b8349d768 (diff) | |
| download | build-coordinator-3768aec91daebb8db58e28cffe481e8878b59700.tar build-coordinator-3768aec91daebb8db58e28cffe481e8878b59700.tar.gz | |
Store build and build results counts in the database
Rather than trying to count all builds and build results at startup. This
should speed up the coordinator starting up, as currently it gets slower the
more builds and build results are in the database.
Diffstat (limited to 'sqitch/pg')
| -rw-r--r-- | sqitch/pg/deploy/build_counts.sql | 7 | ||||
| -rw-r--r-- | sqitch/pg/deploy/build_results_counts.sql | 7 | ||||
| -rw-r--r-- | sqitch/pg/revert/build_counts.sql | 7 | ||||
| -rw-r--r-- | sqitch/pg/revert/build_results_counts.sql | 7 | ||||
| -rw-r--r-- | sqitch/pg/verify/build_counts.sql | 7 | ||||
| -rw-r--r-- | sqitch/pg/verify/build_results_counts.sql | 7 |
6 files changed, 42 insertions, 0 deletions
diff --git a/sqitch/pg/deploy/build_counts.sql b/sqitch/pg/deploy/build_counts.sql new file mode 100644 index 0000000..a7933c0 --- /dev/null +++ b/sqitch/pg/deploy/build_counts.sql @@ -0,0 +1,7 @@ +-- Deploy guix-build-coordinator:build_counts to pg + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/pg/deploy/build_results_counts.sql b/sqitch/pg/deploy/build_results_counts.sql new file mode 100644 index 0000000..c464050 --- /dev/null +++ b/sqitch/pg/deploy/build_results_counts.sql @@ -0,0 +1,7 @@ +-- Deploy guix-build-coordinator:build_results_counts to pg + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/pg/revert/build_counts.sql b/sqitch/pg/revert/build_counts.sql new file mode 100644 index 0000000..fc0af6d --- /dev/null +++ b/sqitch/pg/revert/build_counts.sql @@ -0,0 +1,7 @@ +-- Revert guix-build-coordinator:build_counts from pg + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/pg/revert/build_results_counts.sql b/sqitch/pg/revert/build_results_counts.sql new file mode 100644 index 0000000..49e9f10 --- /dev/null +++ b/sqitch/pg/revert/build_results_counts.sql @@ -0,0 +1,7 @@ +-- Revert guix-build-coordinator:build_results_counts from pg + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/pg/verify/build_counts.sql b/sqitch/pg/verify/build_counts.sql new file mode 100644 index 0000000..da2483a --- /dev/null +++ b/sqitch/pg/verify/build_counts.sql @@ -0,0 +1,7 @@ +-- Verify guix-build-coordinator:build_counts on pg + +BEGIN; + +-- XXX Add verifications here. + +ROLLBACK; diff --git a/sqitch/pg/verify/build_results_counts.sql b/sqitch/pg/verify/build_results_counts.sql new file mode 100644 index 0000000..447cb20 --- /dev/null +++ b/sqitch/pg/verify/build_results_counts.sql @@ -0,0 +1,7 @@ +-- Verify guix-build-coordinator:build_results_counts on pg + +BEGIN; + +-- XXX Add verifications here. + +ROLLBACK; |