I keep a reminder task to download backups. I use this topic to record it happening, and sizes.
1 Like
-rw-r--r--. 1 maiki maiki 14M Jul 2 11:20 talkgroup-2021-06-30-033613-v20210601002145.tar.gz
-rw-r--r--. 1 maiki maiki 218M Jul 2 11:25 talkgroup-2021-07-02-033135-v20210617202227.sql.gz
-rw-r--r--. 1 maiki maiki 17M Aug 1 15:05 talkgroup-2021-07-29-033124-v20210713092503.tar.gz
-rw-r--r--. 1 maiki maiki 78M Aug 4 14:00 talkgroup-2021-08-04-033548-v20210714173022.sql.gz
That seems like a dramatic decrease in size for the database… maybe there was an update that jump-started a queue to clear out old deleted topics or something… 
-rw-r--r-- 1 maiki maiki 17M Aug 31 09:51 talkgroup-2021-08-26-033604-v20210713092503.tar.gz
-rw-r--r-- 1 maiki maiki 76M Aug 31 13:03 talkgroup-2021-08-31-033603-v20210714173022.sql.gz
v1 backup is down 2MB. Fascinating! I think it is from processing popular topics, which have a lot of text, and the text reduction is what we’re seeing.
-rw-r--r-- 1 maiki maiki 14M Oct 1 18:06 talkgroup-2021-09-30-033256-v20210824203421.tar.gz
-rw-r--r-- 1 maiki maiki 75M Oct 1 18:16 talkgroup-2021-10-01-033214-v20210824203421.sql.gz
-rw-r--r-- 1 maiki maiki 13M Nov 1 12:53 talkgroup-2021-10-28-033903-v20211019092048.tar.gz
-rw-r--r-- 1 maiki maiki 72M Nov 1 13:01 talkgroup-2021-11-01-033950-v20211019092048.sql.gz
Always neat to see how the sizes change over time. I’ll have to graph it at some point.
A recent version of Discourse now has the option to permanently delete content from the database, which is great, because now I we can fill it up with nonsense posts and experiments!
-rw-r--r-- 1 maiki maiki 12M Dec 1 11:50 talkgroup-2021-11-25-033321-v20211019092048.tar.gz
-rw-r--r-- 1 maiki maiki 72M Dec 1 11:48 talkgroup-2021-12-01-033605-v20211108023921.sql.gz
-rw-r--r-- 1 maiki maiki 13M Dec 31 10:51 talkgroup-2021-12-30-033654-v20211221164540.tar.gz
-rw-r--r-- 1 maiki maiki 72M Dec 31 10:52 talkgroup-2021-12-31-033225-v20211221164540.sql.gz
-rw-r--r-- 1 maiki maiki 18M Jan 31 14:32 talkgroup-2022-01-27-033046-v20220107014925.tar.gz
-rw-r--r-- 1 maiki maiki 74M Jan 31 14:36 talkgroup-2022-01-31-033651-v20220107014925.sql.gz
-rw-r--r-- 1 maiki maiki 20M Mar 1 08:57 talkgroup-2022-02-24-033110-v20220202225716.tar.gz
-rw-r--r-- 1 maiki maiki 74M Mar 1 08:57 talkgroup-2022-03-01-033605-v20220202225716.sql.gz
-rw-r--r-- 1 maiki maiki 22M Apr 1 09:40 talkgroup-2022-03-31-033141-v20220316150247.tar.gz
-rw-r--r-- 1 maiki maiki 74M Apr 1 09:40 talkgroup-2022-04-01-033242-v20220202225716.sql.gz
-rw-r--r-- 1 maiki maiki 19M Aug 1 13:07 talkgroup-2022-07-28-033651-v20220724130519.tar.gz
-rw-r--r-- 1 maiki maiki 72M Aug 1 13:08 talkgroup-2022-08-01-033446-v20220628031850.sql.gz
-rw-r--r-- 1 maiki maiki 15M Nov 13 11:30 talkgroup-2022-11-10-033153-v20220724130519.tar.gz
-rw-r--r-- 1 maiki maiki 72M Nov 13 11:30 talkgroup-2022-11-13-033834-v20221027090832.sql.gz