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?
On Thu, May 30, 2013 at 12:17 PM, Igor Neyman <iney...@perceptron.com>wrote: > > > From: Rodrigo Barboza [mailto:rodrigombu...@gmail.com] > Sent: Thursday, May 30, 2013 11:10 AM > To: Igor Neyman > Cc: pgsql-admin@postgresql.org > Subject: Re: [ADMIN] How do I know my table is bloated? > > Well, so I need to do reindex frequentely in database? Is that right? > Or should I use cluster, as David said? > How frequently should I do this operation? > > --------------------- > > Not necessarily. > If there is no table or index bloat, which you should be able to check > first, - why bother? > > Normally autovacuum does pretty good job even with default configuration > parameters. > If not, you could start with adjusting autovacuum parameters. > And reindex only as a last resort, when your index size grows > "uncontrollably". > > Igor Neyman >
