Boguk Maxim <astar@xxxxxxxxxxxxx> 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
