Skip site navigation (1) Skip section navigation (2)

Re: Some strange issues with VACUUM on one table.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Boguk Maxim <astar(at)rambler-co(dot)ru>
Cc: "'Gourish Singbal'" <gourish(at)gmail(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Some strange issues with VACUUM on one table.
Date: 2005-12-20 14:52:35
Message-ID: 28966.1135090355@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
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 HooverDate: 2005-12-20 15:12:36
Subject: Re: PG8.1 - Config file check
Previous:From: Patrice BeliveauDate: 2005-12-20 14:34:58
Subject: cache lookup failed for type

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group