Re: disk space usage enlarging despite vacuuming

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: disk space usage enlarging despite vacuuming
Дата
Msg-id 3326.1053836305@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: disk space usage enlarging despite vacuuming  (Tzvetan Tzankov <ceco@noxis.net>)
Список pgsql-general
Tzvetan Tzankov <ceco@noxis.net> writes:
> only the DB wallet, now is 1.3G !!! after full vacuum and reindexall

> with relation_size from dbsize I got the following things for the system
> tables, wich are not very frustraiting I think

> pg_attribute 11M
> pg_class 8M
> pg_depend 2.5M
> pg_type 1.5M

> (if the returned value is bytes ;-)), I put only the tables that are
> larger then 1M)

> mine tables are also with normal sizes, the sume of them is about 100M
> in this DB there are no large objects at all

Then you've still got about 1.2G left to account for, no?

Have you looked at the sizes of indexes, as opposed to tables?

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Iterating through individual fields of OLD/NEW records in plpgsql trigger
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: PLPERL