asif ali <asif_icrossing@xxxxxxxxx> 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
