Ross Boylan <RossBoylan@xxxxxxxxxxxxxxxxxx> writes: > reindexing had a huge effect. So the indexes were indeed bloated. There are some known usage patterns in which regular vacuum isn't very good at reclaiming space in b-tree indexes. For example if you make daily entries in an index by date and later remove all but the last-of-the-month entry --- this leaves a few entries on every index page and we don't have code to collapse that, short of reindexing. However what seems more likely is that you're getting burnt by excessive use of VACUUM FULL. V.F., far from shrinking indexes, tends to bloat them. Recommended practice is to use plain VACUUM often enough that you don't need VACUUM FULL. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
