kim
4e935d03fc
- adds home timeline specific index (mostly used by postgres, but used by sqlite for larger queries, all credit to @cdn0x12) - adds local timeline specific index (again, all credit to @cdn0x12) - fine tunes some existing indices to further reduce size with partial clauses - fine tunes some existing indices to reduce columns not actually queried on Co-Authored by: @cdn0x12 Reviewed-on: https://codeberg.org/superseriousbusiness/gotosocial/pulls/4761 Co-authored-by: kim <grufwub@gmail.com> Co-committed-by: kim <grufwub@gmail.com>
11 lines
226 B
Bash
Executable File
11 lines
226 B
Bash
Executable File
#!/bin/bash
|
|
set -ex
|
|
|
|
rm -f /tmp/sqlite.db
|
|
|
|
env \
|
|
GTS_DB_TYPE=sqlite \
|
|
GTS_DB_ADDRESS=/tmp/sqlite.db \
|
|
GTS_LOG_LEVEL=trace \
|
|
GTS_PORT=${GTS_DB_PORT:-${RANDOM}} \
|
|
go run -v -tags='debug nopostgres' ./cmd/gotosocial testrig start |