Re: Giant TOAST tables due to many almost empty pages

Rumko <rumcic@gmail.com> writes:
> On Thursday 13. of May 2010 21:43:37 Tom Lane wrote:
>> Do *any* of the rows in pg_class have non-null reloptions?

> First of all, really sorry.
> "select reloptions from pg_class where relname = 'pg_toast_1066371';"
> Returns "{autovacuum_enabled=false}" (a remnant of some testing/playing) and
> not NULL (was looking at the wrong server).

> As for the others in pg_class, there is an index for a totally different table
> which has "{fillfactor=90}". There are a few more tables (main and toast)
> with "{autovacuum_enabled=false}" and that's it (others have NULL).

Hmm, do both of the toast tables with bloat problems have
"{autovacuum_enabled=false}" ?

            regards, tom lane