Alvaro Herrera <alvherre@xxxxxxxxxxxxxxxxx> writes: > I'm not having much luck really. I think the problem is that ANALYZE > stores reltuples as the number of live tuples, so if you delete a big > portion of a big table, then ANALYZE and then VACUUM, there's a huge > misestimation and extra index cleanup passes happen, which is a bad > thing. Yeah ... so just go with a constant estimate of say 200 deletable tuples per page? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
