aboutsummaryrefslogtreecommitdiffhomepage
path: root/bin/cleandb
diff options
context:
space:
mode:
authorwinter2025-01-19 23:49:31 +0000
committerwinter2025-01-19 23:49:31 +0000
commit55433eeca50ff840cb0b660f8f9de44b2bc6825f (patch)
treee4ddec94902bb46966ac0f658617147b25743cec /bin/cleandb
parentbf031d9a72a34922f3ac8ccdf5212a384103fc80 (diff)
allow old sessions to get cleaned up
Diffstat (limited to 'bin/cleandb')
-rwxr-xr-xbin/cleandb3
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