Re: How to avoid database bloat

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Mindaugas Riauba" <mind(at)bi(dot)lt>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: How to avoid database bloat
Date: 2005-06-01 14:39:59
Message-ID: 13878.1117636799@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"Mindaugas Riauba" <mind(at)bi(dot)lt> writes:
> Our database increases in size 2.5 times during the day.
> What to do to avoid this? Autovacuum running with quite
> aggressive settings, FSM settings are high enough.

First thing I'd suggest is to get a more detailed idea of exactly
what is bloating --- which tables/indexes are the problem?

regards, tom lane

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Keith Worthington 2005-06-01 15:31:13 Moving pg_xlog
Previous Message Alvaro Herrera 2005-06-01 13:40:09 Re: TIP 9: the planner will ignore... & datatypes