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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
