| From: | "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
|---|---|
| To: | "Rik Bellens *EXTERN*" <rik(dot)bellens(at)telin(dot)ugent(dot)be>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: strange table disk sizes |
| Date: | 2011-09-01 14:32:23 |
| Message-ID: | D960CB61B694CF459DCFB4B0128514C206D6C962@exadv11.host.magwien.gv.at |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2011-09-01 14:46:40 | Re: Memory leak somewhere at PQconnectdb? |
| Previous Message | Sim Zacks | 2011-09-01 14:26:44 | Re: md5 of table |