Re: Giant TOAST tables due to many almost empty pages

On Friday 14. of May 2010 19:29:44 Tom Lane wrote:
> 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 =3D 'pg_toast_1066371';"
> > Returns "{autovacuum_enabled=3Dfalse}" (a remnant of some testing/playi=
ng)
> > 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=3D90}". There are a few more tables (main =
and
> > toast) with "{autovacuum_enabled=3Dfalse}" and that's it (others have
> > NULL).
>
> Hmm, do both of the toast tables with bloat problems have
> "{autovacuum_enabled=3Dfalse}" ?

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

>
>             regards, tom lane
--=20
Regards,
Rumko