diff options
| author |  tobi <31960611+tsmethurst@users.noreply.github.com> | 2022-03-07 11:08:26 +0100 |
|---|---|---|
| committer |  GitHub <noreply@github.com> | 2022-03-07 11:08:26 +0100 |
| commit | 07727753b96d209406783e5e539725bcdafebdc7 (patch) | |
| tree | b32f11cbc304d633ed0acd8f84b4c11e909bb5f3 /vendor/modernc.org/sqlite/tpch.sh | |
| parent | [documentation] Creates Docker documentation and docker-compose.yaml (#416) (diff) | |
| download | gotosocial-07727753b96d209406783e5e539725bcdafebdc7.tar.xz | |
[feature] Clean up/uncache remote media (#407)
* Add whereNotEmptyAndNotNull
* Add GetRemoteOlderThanDays
* Add GetRemoteOlderThanDays
* Add PruneRemote to Manager interface
* Start implementing PruneRemote
* add new attachment + status to tests
* fix up and test GetRemoteOlderThan
* fix bad import
* PruneRemote: return number pruned
* add Cached column to mediaattachment
* update + test pruneRemote
* update mediaTest
* use Cached column
* upstep bun to latest version
* embed structs in mediaAttachment
* migrate mediaAttachment to new format
* don't default cached to true
* select only remote media
* update db dependencies
* step bun back to last working version
* update pruneRemote to use Cached field
* fix storage path of test attachments
* add recache logic to manager
* fix trimmed aspect ratio
* test prune and recache
* return errwithcode
* tidy up different paths for emoji vs attachment
* fix incorrect thumbnail type being stored
* expose TransportController to media processor
* implement tee-ing recached content
* add thoughts of dog to test fedi attachments
* test get remote files
* add comment on PruneRemote
* add postData cleanup to recache
* test thumbnail fetching
* add incredible diagram
* go mod tidy
* buffer pipes for recache streaming
* test for client stops reading after 1kb
* add media-remote-cache-days to config
* add cron package
* wrap logrus so it's available to cron
* start and stop cron jobs gracefully
Diffstat (limited to 'vendor/modernc.org/sqlite/tpch.sh')
| -rw-r--r-- | vendor/modernc.org/sqlite/tpch.sh | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/vendor/modernc.org/sqlite/tpch.sh b/vendor/modernc.org/sqlite/tpch.sh new file mode 100644 index 000000000..46037bfbf --- /dev/null +++ b/vendor/modernc.org/sqlite/tpch.sh @@ -0,0 +1,20 @@ +set -e +echo "See http://www.tpc.org/tpc_documents_current_versions/pdf/tpc-h_v2.17.1.pdf for details" +tmp=$(mktemp -d) +cd $tmp +echo "installing modernc.org/sqlite/tpch@latest into $tmp" +GOBIN=$tmp go install modernc.org/sqlite/tpch@latest +echo "generating pseudotext" +./tpch -pseudotext +for sf in 1 10 ; do + for sut in sqlite3 sqlite ; do + echo "$sut: generating a $sf GB test DB" + time -p ./tpch -sut $sut -dbgen -sf $sf + for q in 1 2 ; do + echo -n "$sut: running query $q: " + ./tpch -sut $sut -q $q -sf $sf + done + done +done +cd - +rm -rf $tmp |