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 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
