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