tl;dr: it looks like there are about 10GB of data reported by rake db:stats, but postgres_data is taking up 18GB. Does it seem likely that there are 8GB of indexes taking up the rest of the space, or is there some kind of cleanup that needs to be done? Longer version of the same question The postgr…

You may have a restore schema with tables, try list those with psql.

Thanks. Is this what I’m looking for? I don’t think I see a restore schema, but I’m not quite sure what I’m looking for. List of relations Schema Name Type Owner public api_keys table discourse public application_requests table discourse public ar_internal_metadata tabl…

Is that giant inline table really necessary?

Our Discourse post-timings table size is about 17GB. Is this normal? table_name row_estimate table_size index_size total_size post_timings 120967448 6676 MB 10 GB 17 GB posts 3616224 2413 MB 3219 MB 5632 MB user_actions 15159571 1215 MB 3699 MB 4914 MB post_search_data 3531969 3756 MB …

Yes, that is the largest table in any active Discourse site, with one of the indexes on it taking most of the space. We will rollout an update to PostgreSQL this year that will make it take half that space, so stay tuned :wink:

数据库似乎异常庞大

产品支持安装

Falco (Falco) 2020 年11 月 8 日 15:31 6

是的，这是任何活跃 Discourse 站点中最大的表，其上的一个索引占用了大部分空间。

我们今年将推出 PostgreSQL 的更新，使该表占用空间减少一半，敬请期待

话题		回复	浏览量
Why my discourse postgres_data is too big Self-hosting	16	2334	2021 年9 月 27 日
Database size/maintenance Self-hosting	1	721	2022 年9 月 7 日
Database cleanup before PostgreSQL 18 upgrade: recommended retention period for log/statistics tables? Product Support	2	146	2026 年8 月 3 日
Redis_data & Postgres_data are eating my 20GB+ Space Product Support postgres	16	433	2024 年12 月 8 日
Get basic database table, size and count statistics Sysadmins how-to	3	3069	2019 年7 月 3 日

数据库似乎异常庞大

相关话题