From: Tom Lane <tgl@sss.pgh.pa.us>
To: gleeco <gleeco@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: vacuum toast loop?
Date: Wed, 11 Jan 2017 17:46:52 -0500
Message-ID: <21880.1484174812@sss.pgh.pa.us> (raw)
In-Reply-To: <CADv14s8qPt8f2B5-0g05ThnMqjdDvkJ2QbOPnxPsmiNcd=37sQ@mail.gmail.com>
References: <CADv14s-_fm=dbwAFSFPK-upEQh033Dh6zAML2UVP-Etzjnd+Sg@mail.gmail.com>
<30625.1484053468@sss.pgh.pa.us>
<CADv14s8qPt8f2B5-0g05ThnMqjdDvkJ2QbOPnxPsmiNcd=37sQ@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
gleeco <gleeco@gmail.com> writes:
> Main question now: is there actually new work getting done when it
> repeats? ie. am i making progress?
Yes, I would expect so, especially since the tuple counts are varying
a bit. If it were always exactly the same tuple count then there might
be some reason to worry. If you weren't seeing any verbose output at
all, there would be much more reason to worry.
(FWIW, as of 9.6 or thereabouts there's some support for vacuum progress
tracking via pg_stat_activity. Won't help you now, but it's out there.)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, gleeco@gmail.com
Subject: Re: vacuum toast loop?
In-Reply-To: <21880.1484174812@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox