Re: json datatype and table bloat?

John R Pierce <pierce@xxxxxxxxxxxx> · Tue, 29 Oct 2013 12:49:10 -0700



    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.

    
    -- 
john r pierce                                      37N 122W
somewhere on the middle of the left coast