Boguk Maxim <astar(at)rambler-co(dot)ru> 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
In response to
pgsql-admin by date
|Next:||From: Chris Hoover||Date: 2005-12-20 15:12:36|
|Subject: Re: PG8.1 - Config file check|
|Previous:||From: Patrice Beliveau||Date: 2005-12-20 14:34:58|
|Subject: cache lookup failed for type|