Re: Table seems empty but its size is in gigabytes

John R Pierce <pierce@xxxxxxxxxxxx> · Tue, 12 Apr 2016 09:30:09 -0700



    On 4/12/2016 9:16 AM, David G. Johnston
      wrote:

    
                Now my big
                    table statistics shows tuples inserted and its size
                    is in order of gigabytes,
                    but a simple SELECT has no rows, is there any way to
                    recover the data in
                    this table?
              
            
        Do you want to
          recover the dead data or the space that it consumes?
        

    to free the disk space, use...

    
        vacuum full tablename;

    
    I don't know how to reclaim tuples that were written but rolled
    back.

    
    -- 
john r pierce, recycling bits in santa cruz