Re: Giant TOAST tables due to many almost empty pages

Rumko <rumcic(at)gmail(dot)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