Re: Giant TOAST tables due to many almost empty pages

On Friday 14. of May 2010 19:29:44 Tom Lane wrote:
> Rumko <rumcic(at)gmail(dot)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}" ?

Yeah, but also many others that don't have the problem.

>
> regards, tom lane
--
Regards,
Rumko