|
Hi, We notice that vacuum is happening at regular intervals but the space occupied by indexes is always increasing. Any pointers as to why would this happen? Some outputs below. Auto vacuum is enabled but we notice index size is growing. $ psql -U postgres -d cgms -c "SELECT pg_size_pretty(SUM(pg_relation_size(table_schema||'.'||table_name))) as size from information_schema.tables" size ------- 25 GB (1 row) $ psql -U postgres -d cgms -c "SELECT pg_size_pretty(SUM(pg_indexes_size(table_schema||'.'||table_name) + pg_relation_size(table_schema||'.'||table_name))) as size from information_schema.tables" size -------- 151 GB (1 row) $ sudo du -hsc /var/lib/pgsql/12/data 154G /var/lib/pgsql/12/data 154G total Appreciate if someone can give some pointers. Regards, Karthik |
