>>>>> "DM" == Doug McNaught <[EMAIL PROTECTED]> writes:
DM> The index bloat problem can occur when you have a an indexed SERIAL DM> column whose value always increases, and you delete older rows on a DM> regular basis. VACUUM recycles the row storage, but the index never DM> shrinks. I get this on tables which are updated a lot, even if I don't do any mass deletes of older rows. The indexes on other columns also bloat rapidly on some tables. It is a significant problem, especially since reindex locks the tables for significant amounts of time. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D. Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
