On 4/5/05 11:15 AM, "Tom Lane" <tgl@xxxxxxxxxxxxx> wrote: > I didn't say it wasn't consistent, just that it doesn't prove the > point. The speedup you saw could have been from elimination of index > bloat more than from bringing the index into physically sorted order. > An estimate of the overall database size doesn't really tell us how > much this particular table's indexes changed in size. Ok, now I follow. Taking the biggest indexes: The weekend before: INFO: index "message_recipients_i_recip_date" now contains 393961361 row versions in 2435100 pages INFO: index "message_recipients_i_message" now contains 393934394 row versions in 1499853 pages After reindex: INFO: index "message_recipients_i_recip_date" now contains 401798357 row versions in 1765613 pages INFO: index "message_recipients_i_message" now contains 401787237 row versions in 1322974 pages Wes ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
