>>>>> "TL" == Tom Lane <tgl@sss.pgh.pa.us> writes: TL> Edmund Dengler <edmundd@eSentire.com> writes: >> Searching the web, I find lots of references to index bloat, as >> well as recent discussions concerning index page recovery (such >> items as reclaiming empty B+-tree pages and such). What is the >> current state re bloat? TL> You tell me --- are you still seeing bloat problems with 7.4? TL> If so, can you provide more details about the index schema and TL> the table's update patterns? I had *awful* bloat with 7.2. When I upgraded to 7.4, I noticed less of it, but it was still there. Then I discovered two programs that were sleeping for long times inside of a transaction. Restructuring those to open transactions as needed fixed it all. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D. Khera Communications, Inc. Internet: khera@kciLink.com Rockville, MD +1-301-869-4449 x806 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
