From: Tom Lane <tgl@sss.pgh.pa.us>
To: gleeco <gleeco@gmail.com>
cc: pgsql-admin@postgresql.org
Subject: Re: vacuum toast loop?
In-reply-to: 
 <CADv14s-_fm=dbwAFSFPK-upEQh033Dh6zAML2UVP-Etzjnd+Sg@mail.gmail.com>
References: 
 <CADv14s-_fm=dbwAFSFPK-upEQh033Dh6zAML2UVP-Etzjnd+Sg@mail.gmail.com>
Comments: In-reply-to gleeco <gleeco@gmail.com>
	message dated "Tue, 10 Jan 2017 00:53:06 -0800"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <30624.1484053468.1@sss.pgh.pa.us>
Date: Tue, 10 Jan 2017 08:04:28 -0500
Message-ID: <30625.1484053468@sss.pgh.pa.us>
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

gleeco <gleeco@gmail.com> writes:
> hello - i've a long-running manual vacuum on a big size table.  It's many
> TB db that has some toast.  What is odd is that it keeps looping back on
> the same toast / index, eg.

It's not looping ... it's filling up your maintenance_work_mem (which is
evidently set to 1GB) with dead TIDs and then pausing to do a cycle of
index cleaning.  You have evidently let that table get, um, severely
bloated.  Was autovacuum off?

			regards, tom lane


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