Re: disk space usage enlarging despite vacuuming - Mailing list pgsql-general

From Tom Lane
Subject Re: disk space usage enlarging despite vacuuming
Date
Msg-id 3326.1053836305@sss.pgh.pa.us
Whole thread Raw
In response to Re: disk space usage enlarging despite vacuuming  (Tzvetan Tzankov <ceco@noxis.net>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Iterating through individual fields of OLD/NEW records in plpgsql trigger
Next
From: Alvaro Herrera
Date:
Subject: Re: PLPERL