Re: Unexplained growth of tables - Mailing list pgsql-admin

From Peter Eisentraut
Subject Re: Unexplained growth of tables
Date
Msg-id 200607231319.29697.peter_e@gmx.net
Whole thread Raw
In response to Unexplained growth of tables  ("Benjamin Krajmalnik" <kraj@illumen.com>)
Responses Re: Unexplained growth of tables  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Benjamin Krajmalnik wrote:
> What can be causing this growth?  Not vacuuming often enough?

The is exactly the reason.

> I hav
> pg_autovacuum running every 60 seconds.  These tables have 10-15
> insert/update statements per second.

You should probably run VACUUM FULL to get the table back to a normal
size and then closely monitor what pg_autovacuum actually does.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

pgsql-admin by date:

Previous
From: "Benjamin Krajmalnik"
Date:
Subject: Unexplained growth of tables
Next
From: Christian Kratzer
Date:
Subject: Re: Unexplained growth of tables