From: | Rumko <rumcic(at)gmail(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: Giant TOAST tables due to many almost empty pages |
Date: | 2010-05-14 17:38:08 |
Message-ID: | 201005141938.10953.rumcic@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2010-05-14 18:02:02 | Re: Giant TOAST tables due to many almost empty pages |
Previous Message | Tom Lane | 2010-05-14 17:29:44 | Re: Giant TOAST tables due to many almost empty pages |