Re: Unexplained growth of tables

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Cc: "Benjamin Krajmalnik" <kraj(at)illumen(dot)com>
Subject: Re: Unexplained growth of tables
Date: 2006-07-23 11:19:28
Message-ID: 200607231319.29697.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Christian Kratzer 2006-07-23 12:50:37 Re: Unexplained growth of tables
Previous Message Benjamin Krajmalnik 2006-07-23 10:56:03 Unexplained growth of tables