Re: fsm and vacuum - Mailing list pgadmin-support

From Guillaume Lelarge
Subject Re: fsm and vacuum
Date
Msg-id 4CF91025.7090601@lelarge.info
Whole thread Raw
In response to fsm and vacuum  ("Little, Douglas" <DOUGLAS.LITTLE@orbitz.com>)
List pgadmin-support
Le 03/12/2010 16:24, Little, Douglas a écrit :
> Michael,
> 
> I hear that vacuum full shouldn't be used.
> But what impact does the bloat have on performance?

Bigger on your hard, so slower to scan. And bigger in memory, so you
need to push blocks out to scan it. Other than that, not much.

It's better to not have a lot of bloat. I mean, if you deleted half of
your 20 GB table, it makes sens to do a VACUUM FULL.

> And,   what do we do about the bloat in the pg tables?

Depends on the percentage of bloat and table size.

> I envision this would be a 1 time fix, now that we've got the fsm_relations set properly.

Could be.


-- 
Guillaumehttp://www.postgresql.frhttp://dalibo.com


pgadmin-support by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: fsm and vacuum
Next
From: Guillaume Lelarge
Date:
Subject: Re: fsm and vacuum