diff options
| author | winter | 2025-01-19 23:49:31 +0000 |
|---|---|---|
| committer | winter | 2025-01-19 23:49:31 +0000 |
| commit | 55433eeca50ff840cb0b660f8f9de44b2bc6825f (patch) | |
| tree | e4ddec94902bb46966ac0f658617147b25743cec /bin | |
| parent | bf031d9a72a34922f3ac8ccdf5212a384103fc80 (diff) | |
allow old sessions to get cleaned up
Diffstat (limited to 'bin')
| -rwxr-xr-x | bin/cleandb | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/bin/cleandb b/bin/cleandb index 4aa7b37..44f55f2 100755 --- a/bin/cleandb +++ b/bin/cleandb @@ -16,5 +16,8 @@ DELETE FROM interaction WHERE deleted = true; DELETE FROM home_timeline_item WHERE modified < (current_timestamp - interval '6 months'); DELETE FROM notification WHERE created < (current_timestamp - interval '1 month'); +-- throw away old sessions that would be too old anyway +DELETE FROM session WHERE created < (current_timestamp - interval '1 year'); + END); $db->commit();
\ No newline at end of file |
