Re: Giant TOAST tables due to many almost empty pages - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Giant TOAST tables due to many almost empty pages
Date
Msg-id 18724.1273858184@sss.pgh.pa.us
Whole thread Raw
In response to Re: Giant TOAST tables due to many almost empty pages  (Rumko <rumcic@gmail.com>)
Responses Re: Giant TOAST tables due to many almost empty pages  (Rumko <rumcic@gmail.com>)
List pgsql-bugs
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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_restore ignores -C when using a restore list -L
Next
From: Rumko
Date:
Subject: Re: Giant TOAST tables due to many almost empty pages