Rik Bellens wrote:
> I have two large tables in a database, one containing original data
and
> the other one derived from the first table. The first table contains
> several columns and indexes, while the second table has less columns
and
> only one index. Both tables have the same number of rows.
Nevertheless,
> the second table is much larger in disk size than the first one. How
can
> this be explained?
Maybe the second table contains more empty space.
See
http://www.postgresql.org/docs/9.0/static/routine-vacuuming.html#VACUUM-
FOR-SPACE-RECOVERY
Yours,
Laurenz Albe