Re: VACUUM FULL does not works....... - Mailing list pgsql-performance

asif ali <asif_icrossing@yahoo.com> writes:
>  INFO:  vacuuming "public.product_table"
>  INFO:  "product_table": found 0 removable, 139178 nonremovable row versions in 4305 pages
>  DETAIL:  138859 dead row versions cannot be removed yet.

So Scott's guess was correct: you've got a whole lot of dead rows in
there that will eventually be removable, but not while there's still
an open transaction that might be able to "see" them.  Find your open
transaction and get rid of it (pg_stat_activity might help).

            regards, tom lane