Today I was evaluating my discourse server and found two weird things. 1- If I understand correctly, the discourse postgres_data folder which is in /var/discourse/shared/standalone folder, is where discourse stores the database. Now this folder for my forum is about 8GB. Which I believe is too big …

There was a postgres update recently, there is a old folder in case something went wrong. If your forum works fine, you can execute this command cd /var/discourse ./launcher cleanup app It should clean the old postgres data folder. For the memory, DIscourse works this way, it uses the most memor…

what about the big database? Is it something wrong with my forum? I think its way too larger than it should be.

How many posts do you have ? I’ll let a specialist give you an answer about that. I know that Discourse stores a lot of information to provide relevent statistics and a good search engine I guess. It may not be alarming.

You can run the following commands to see which tables are taking up the most disk space ./launcher enter app su - postgres psql discourse SELECT nspname || '.' || relname AS "relation", pg_size_pretty(pg_total_relation_size(C.oid)) AS "total_size" FROM pg_class C LEFT JOIN pg_namespace N …

This is the output of my forum for these commands. I think the first 5 rows are consuming too much space. I cant imagine why user_actions should be around 2GB. Or post timing about 1GB. Can you give me an idea what could be wrong? On the other hand, is there any way to clean unnecessary data? For e…

Did you do an upgrade recently? I’ve seen a commit about cleaning the email logs table. After the rebuild, it may be lighter Also, you might check the setting delete email logs after days, it should be safer than deleting it manually

Thank you very much. I found this option and changed it from 90 days to 10 days. What about user_actions ? what is stored in this table that it has got so big? I have the same question about post_timings and topic_views too. The names indicate that these should be just a bunch of numbers. And shoul…

[image] hosna: What about user_actions ? what is stored in this table that it has got so big? I have the same question about post_timings and topic_views too. The names indicate that these should be just a bunch of numbers. And shouldn’t take really this much space. You can run a backup, down…

I followed your suggestion and downloaded and extracted the backup. it was about 2GB. Is it normal that its 1/4 of what discourse reports? Btw I realized that a huge amount of data is for excessive number of inactive users. Its more than 100k. Is there an automatic way for deleting all these users?…

[image] hosna: I followed your suggestion and downloaded and extracted the backup. it was about 2GB. Is it normal that its 1/4 of what discourse reports? 2GB was the size of the compressed backup? Also backups don’t include indexes, and they take a lot of space. [image] hosna: Btw I real…

Why my discourse postgres_data is too big

Support Self-hosting

Falco (Falco) July 6, 2018, 2:09pm 9

You can run a backup, download it, and analyze it locally. A pg_dump is just a text file that is human readable and will let you check what exactly is in each table.

Topic		Replies	Views
Database seems inexplicably large Self-hosting hosting	5	1344	November 8, 2020
Database size/maintenance Self-hosting	1	718	September 7, 2022
Redis_data & Postgres_data are eating my 20GB+ Space Support postgres	16	425	December 8, 2024
Database cleanup before PostgreSQL 18 upgrade: recommended retention period for log/statistics tables? Support	2	141	August 3, 2026
Improving Instance Performance (Megatopics, Database Size and Extreme Load) Self-hosting	60	6569	October 13, 2020

Why my discourse postgres_data is too big

Related topics