Rumko <rum...@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

-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

Reply via email to