Re: VACUUM FULL doesn't reduce table size - Mailing list pgsql-general

From pinker
Subject Re: VACUUM FULL doesn't reduce table size
Date
Msg-id 1425917107408-5841137.post@n5.nabble.com
Whole thread Raw
In response to Re: VACUUM FULL doesn't reduce table size  (Kevin Grittner <kgrittn@ymail.com>)
Responses Re: VACUUM FULL doesn't reduce table size  (Bill Moran <wmoran@potentialtech.com>)
List pgsql-general
> So there are no longer any dead rows being left behind, right?
>
> Why are we still discussing this?  Do you have some other question?

There are no dead rows, but postgres still cannot reuse the space because of
3043947 nonremovable row versions ..

INFO:  vacuuming "my_table"
INFO:  "my_table": found 0 removable, 3043947 nonremovable row versions in
37580 pages
DETAIL:  0 dead row versions cannot be removed yet.
CPU 2.67s/1.59u sec elapsed 7.71 sec.
Query returned successfully with no result in 8319 ms.



--
View this message in context: http://postgresql.nabble.com/VACUUM-FULL-doesn-t-reduce-table-size-tp5840782p5841137.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: VACUUM FULL doesn't reduce table size
Next
From: Bill Moran
Date:
Subject: Re: VACUUM FULL doesn't reduce table size