On Thu, May 30, 2013 at 1:35 PM, Igor Neyman <iney...@perceptron.com> wrote:
> > > From: Rodrigo Barboza [mailto:rodrigombu...@gmail.com] > Sent: Thursday, May 30, 2013 12:04 PM > To: Igor Neyman > Cc: pgsql-admin@postgresql.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?
