On Tue, Jan 6, 2009 at 9:05 AM, Grzegorz Jaśkiewicz <gryzman@xxxxxxxxx> wrote:> you don't have to reindex too often - it locks exclusively whole> table, just like vacuum full. Just do it every few months, depending> on db growth. While I don't wholly disagree with periodic reindexing, I do recommendthat one keeps track of bloat. It's easy enough to have an alarm thatgoes off if any index gets over 50% dead space, then go look at thedatabase. Or go in every week and see what vacuum verbose looks like. Even if you just email yourself a copy of the last 10 or 15 linesevery morning or something to see how bloated the db is in general,you'll catch most problems before they become problems. One or tworogue updates without where clauses on medium to large sized tablescan blow you right out of the water. Best to have some way to keeptrack of them. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-general
