Re: json datatype and table bloat?

John R Pierce <pierce(at)hogranch(dot)com> writes:
> On 10/29/2013 12:41 PM, Gregory Haase wrote:
>> db_name=# VACUUM FULL VERBOSE table_schema.table_name;
>> INFO: vacuuming "table_schema.table_name"
>> INFO: "table_name": found 2 removable, 29663 nonremovable row
>> versions in 1754 pages
>> DETAIL: 0 dead row versions cannot be removed yet.
>> CPU 0.07s/0.10u sec elapsed 0.30 sec.

> is there an old transaction pending? that 'masks' vacuum from touching
> any tuples newer than the start of that transaction.

If old transactions were the problem, vacuum would be reporting that
some-large-number of dead row versions couldn't be removed yet.

There doesn't seem to be anything obviously wrong here.

regards, tom lane