From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | jlliu <jlliu(at)avaya(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Why pg_toast table not get auto vacuumed? |
Date: | 2014-07-17 14:10:11 |
Message-ID: | 53C7D943.4000004@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 07/16/2014 12:05 PM, jlliu wrote:
> Hi,
>
> PostgreSQL version: 9.1.16. Linux: RHEL6.
>
> After a heavy traffic run, a huge pg_toast table is seen. Its size is ~3G.
> There also exist other pg_toast tables in a much smaller size, for example,
> ~100M. The problem is that that huge pg_toast table never gets auto vacuumed
> while other small pg_toast tables do get auto vacuumed, as shown in pg logs.
> If running traffic again, the huge pg_toast table grows again.
In psql see if \d+ on the parent table shows autovacuum has been
disabled for that table.
>
> We have another system with the same setup but we only run light traffic on
> it. The pg_toast table from the same parent table also exists. But this
> pg_toast table only has a size ~50M and it gets auto vacuumed from time to
> time as shown in pg_logs.
>
> Why does not the huge pg_toast table in the first case get auto vacuumed?
> Are there anything we can do?
A start would be to show what your autovacuum settings in
postgresql.conf are:
http://www.postgresql.org/docs/9.3/interactive/runtime-config-autovacuum.html
Also the information from pg_stat_all_tables for that table:
http://www.postgresql.org/docs/9.1/static/monitoring-stats.html
>
> Thanks,
> JL
>
>
>
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Wolfgang Keller | 2014-07-17 14:30:40 | Re: Windows Installation User account - Correct database for us |
Previous Message | D'Arcy J.M. Cain | 2014-07-17 13:48:53 | Re: How can I group all children by their parent ? |