Alvaro Herrera <[EMAIL PROTECTED]> 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
