Hi all. I have a question regarding postgres 9.2.9. Database

Question

Hi all. I have a question regarding postgres 9.2.9. Database

size is 1.2TB. Each table size check shows that it totally uses 15 GB. Vacuum was not used for 8 years. One table is in disk bad block state, so I skip it on backup (pg_dump did not finish in 2 days no errors). How to check what uses so much space, if not tables? (могу на русском переписать)

#backend #devops #pgsql #programming #russian

0

02.12.2020

6 ответов

4 просмотра

Alfred Автор вопроса

Дмитрий Лукьянов
Vacuum was not used for 8 years ... How to check w...

ваккум проверил полей для удаления не много

0

02.12.2020

Дмитрий Лукьянов

Alfred
ваккум проверил полей для удаления не много

SELECT relname AS ObjectName ,pg_stat_get_live_tuples(c.oid) AS LiveTuples ,pg_stat_get_dead_tuples(c.oid) AS DeadTuples FROM pg_class c ORDER BY 3 desc; В основной пользовательской базе что выдаёт? Нет DeadTuples?

0

02.12.2020

Alfred Автор вопроса

Дмитрий Лукьянов
SELECT relname AS ObjectName ,pg_stat_get_liv...