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