Thread: Why the table allocates so much Space ?

Why the table allocates so much Space ?

From
"Roth, Michael J."
Date:

Hi,

we're using PostgreSQL 7.1.3 (after an upgrade from 7.0.3).
Now we lost good performance on our Server, all the
db-operations take a long time.

OK, we try vacuumdb and see the following:

.....
NOTICE:  Analyzing...
NOTICE:  --Relation commuser--
NOTICE:  Pages 1222: Changed 0, reaped 1129, Empty 0, New 0; Tup 5251: Vac 63103
, Keep/VTL 0/0, Crash 0, UnUsed 253, MinLen 124, MaxLen 308; Re-using: Free/Avai
l. Space 8966056/8959140; EndEmpty/Avail. Pages 0/1128. CPU 0.03s/0.03u sec.
NOTICE:  Rel commuser: Pages: 1222 --> 94; Tuple(s) moved: 5251. CPU 0.38s/0.23u
 sec.
.....

After this, here's the "normal space" and the performance is ok:

.....
NOTICE:  Analyzing...
NOTICE:  --Relation commuser--
NOTICE:  Pages 94: Changed 0, reaped 86, Empty 0, New 0; Tup 5251: Vac 0, Keep/V
TL 0/0, Crash 0, UnUsed 262, MinLen 124, MaxLen 308; Re-using: Free/Avail. Space
 6784/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
.....

But only a few Minutes later, we lost performance again and vaccumdb say's:

.....
NOTICE:  --Relation commuser--
NOTICE:  Pages 283: Changed 0, reaped 190, Empty 0, New 0; Tup 5251: Vac 10582,
Keep/VTL 0/0, Crash 0, UnUsed 251, MinLen 124, MaxLen 308; Re-using: Free/Avail.
 Space 1502280/1495404; EndEmpty/Avail. Pages 0/189. CPU 0.02s/0.00u sec.
NOTICE:  Rel commuser: Pages: 283 --> 94; Tuple(s) moved: 5251. CPU 0.05s/0.06u
sec.
.....

So we _must_ vacuum the db all 10-15 minutes.
What's going wrong here ?

Regards,
M. Roth

--
Computers are like airconditioners: They stop
working properly if you open windows.
----------------------------------------------------
Michael J. Roth     mailto:MichaelRoth@schmuecker.de
Tel: 069/57005-421, Fax: 069/57005-800
Schmücker&Partner GmbH      http://www.schmuecker.de
Lurgiallee 14, 60539 Frankfurt           
----------------------------------------------------