Re: How to avoid database bloat - Mailing list pgsql-performance

From matthew@tocr.com
Subject Re: How to avoid database bloat
Date
Msg-id 31520.68.175.84.212.1117769898.squirrel@mail.tocr.com
Whole thread Raw
In response to Re: How to avoid database bloat  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
> "Mindaugas Riauba" <mind@bi.lt> writes:
>>   And what in vacuum verbose output suggests that vacuum is not done
>> often enough? Current output (table is 100MB already) is below.
>
> The output shows vacuum cleaning up about a third of the table.  Usually
> people like to keep the overhead down to 10% or so ...


He was running with -V 0.5 which should transalate to roughly 50% of the
table being touched before a vacuum is issued.j

Matt

pgsql-performance by date:

Previous
From: Bahadur Singh
Date:
Subject: Re: BUG #1697: Select getting slower on continously updating data
Next
From: K C Lau
Date:
Subject: SELECT DISTINCT Performance Issue