Re: Giant TOAST tables due to many almost empty pages

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Rumko <rumcic(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Giant TOAST tables due to many almost empty pages
Date: 2010-05-12 20:17:18
Message-ID: 4857.1273695438@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruce Momjian 2010-05-12 20:46:17 Re: [ANNOUNCE] Bug-fix and new feature of pg_lesslog is released
Previous Message Rumko 2010-05-12 19:23:35 Giant TOAST tables due to many almost empty pages