From: Rodrigo Barboza [mailto:rodrigombufrj@xxxxxxxxx] Sent: Thursday, May 30, 2013 12:04 PM To: Igor Neyman Cc: pgsql-admin@xxxxxxxxxxxxxx Subject: Re: 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
