Alexandre de Arruda Paes <adaldeia(at)gmail(dot)com> writes:
> I know the problem with VACUUM FULL and bloated Indexes, but I don't
> understand why the table that is not in use by nobody, cant be vacuumed or
> clustered to avoid dead tuples.
There's an open transaction somewhere that VACUUM is preserving the
tuples for. This transaction need not ever have touched the table,
or ever intend to touch the table --- but VACUUM cannot know that,
so it saves any tuples that the transaction might be entitled to see
if it looked.
> carmen=# select * from vlocks where relname='tp93t'; select * from
> pg_stat_activity where usename='webpa';
You keep on showing us only subsets of pg_stat_activity :-(
Also, if you don't see anything in pg_stat_activity, try pg_prepared_xacts.
regards, tom lane
In response to
pgsql-performance by date
|Next:||From: Clemens Eisserer||Date: 2010-08-18 13:51:22|
|Subject: Are Indices automatically generated for primary keys?|
|Previous:||From: Alexandre de Arruda Paes||Date: 2010-08-18 13:07:17|
|Subject: Fwd: Vacuum Full + Cluster + Vacuum full = non removable