Rumko <rum...@gmail.com> writes:
> INFO: vacuuming "pg_toast.pg_toast_1066371"
> INFO: "pg_toast_1066371": found 0 removable, 3259181 nonremovable row
> versions
> in 3259181 pages
> DETAIL: 0 dead row versions cannot be removed yet.
> Nonremovable row versions range from 57 to 122 bytes long.
> There were 0 unused item pointers.
> Total free space (including removable row versions) is 0 bytes.
> 0 pages are or will become empty, including 0 at the end of the table.
> 0 pages containing 0 free bytes are potential move destinations.
There's something extremely wacko about that vacuum output. A toast
table should have few, if any, rows that short. And it's impossible
to believe there's no free space at all in the table, especially since
122*3259181 bytes is still quite a lot less than 3259181 pages. Are
you running with any nonstandard storage or vacuum parameters?
regards, tom lane
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
