Re: How do I know my table is bloated?

On Thu, May 30, 2013 at 1:35 PM, Igor Neyman <ineyman(at)perceptron(dot)com> wrote:

>
>
> From: Rodrigo Barboza [mailto:rodrigombufrj(at)gmail(dot)com]
> Sent: Thursday, May 30, 2013 12:04 PM
> To: Igor Neyman
> Cc: pgsql-admin(at)postgresql(dot)org
> Subject: Re: [ADMIN] How do I know my table is bloated?
>
> I have some tables that I do a lot of updates, deletes and inserts.
> So I am worried that my cluster can grow up to a huge size...
> The best option would be to create a scheduled process to check if it is
> bloated and if so, reindex?
>
> --------------------------
>
> Depends on whether it's table bloat or index bloat.
> But first, you try to minimize bloat by tuning autovacuum.
>
> Igor Neyman
>
>
I am using the defualt values for autovaccum.
How do you suggest to tune the autovacuum?
If the problem is index bloat, autovaccum won't be a solution, am I right?