Skip site navigation (1) Skip section navigation (2)

Re: Giant TOAST tables due to many almost empty pages

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 (view raw or flat)
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

In response to

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2010-05-14 18:02:02
Subject: Re: Giant TOAST tables due to many almost empty pages
Previous:From: Tom LaneDate: 2010-05-14 17:29:44
Subject: Re: Giant TOAST tables due to many almost empty pages

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group