Boguk Maxim <[EMAIL PROTECTED]> writes:
> I trying understand why vacuum analyze do not work at all.
I think either you're not actually applying vacuum analyze at all
(better double-check your daily maintenance script), or you're somehow
managing to apply it at a time when it can't remove old rows because
there's still an open transaction that might be able to see those rows.
The latter theory doesn't really explain continuing table growth over
time, though, unless you've got a transaction that's been sitting open
the entire time.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
