database size grows (even after vacuum (full and analyze))....

From: Joao Miguel Ferreira <jmf(at)estg(dot)ipvc(dot)pt>
To: pgsql-novice(at)postgresql(dot)org
Subject: database size grows (even after vacuum (full and analyze))....
Date: 2006-05-03 11:02:18
Message-ID: 1146654138.2340.56.camel@sandoval
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-novice

Hello all,

My subject has been discussed before. I've browsed through the archives
and did what I could understand (I'm doing "vaccum analyze" on each of
my tables every 30 minutes and "vacuum full" on each of the tables every
2 hour).

My database gets about 30 INSERTs per minute, about 60 UPDATEs per
minute and about 30 DELETEs per minute in a way that line counts tend to
stabilize. The test is done in such a way that I can asure a constant
average rate of INSERTs and the same average rate of DELETEs (after a
certain life time for each record).

Dispite this, the file system size still grows (at about 500KB in about
1000 minutes).

I've placed here a pdf file showing my situation. It shows that line
counts tend do stabilize. But pg data size slowlly increases (the sudden
drops are the result of vacuum full, time unit is 5 minutes).
http://robotica.estg.ipvc.pt/software/linux/dbsizes.pdf

Can anyone tell me if this is ok, or should I atend to this matter. My
system is supposed to work continuouslly without maintenance.

Thank you

joao

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Erik Myllymaki 2006-05-03 13:35:33 Re: logfiles filling up
Previous Message Wayne Conrad 2006-05-03 07:56:31 Re: Using the REPLACE command to replace all vowels

Browse pgsql-novice by date

  From Date Subject
Next Message Bruno Wolff III 2006-05-03 13:40:18 Re: Forgotten Password
Previous Message Sean Davis 2006-05-03 10:33:56 Re: Snapshot Copy of a Postgres DB