From: Kevin Grittner <kgrittn@ymail.com>
To: Scott Marlowe <scott.marlowe@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Mike Broers <mbroers@gmail.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Cc: pgsql-hackers@postgresql.org <pgsql-hackers@postgresql.org>
Cc: Jan Wieck <JanWieck@yahoo.com>
Subject: Re: after 9.2.4 patch vacuumdb -avz not analyzing all tables
Date: Fri, 12 Apr 2013 08:36:12 -0700 (PDT)
Message-ID: <1365780972.41333.YahooMailNeo@web162906.mail.bf1.yahoo.com> (raw)
In-Reply-To: <CAOR=d=2sAp5YwXQ6i5361jNeh51jqtg-2GYUJe6bgeT2Y_+QxA@mail.gmail.com>
References: <CAB9893het38CbHoHOt=GZ5tuUnb77EauGidjHsyy7Mqu_4_P9w@mail.gmail.com>
<28473.1365724754@sss.pgh.pa.us>
<1365731282.15026.YahooMailNeo@web162905.mail.bf1.yahoo.com>
<CAOR=d=2sAp5YwXQ6i5361jNeh51jqtg-2GYUJe6bgeT2Y_+QxA@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Scott Marlowe <scott.marlowe@gmail.com> wrote:
> Does this behavior only affect the 9.2 branch? Or was it ported
> to 9.1 or 9.0 or 8.4 as well?
After leaving it on master for a while to see if anyone reported
problems in development, I back-patched as far as 9.0 in time for
the 9.2.3 (and related) patches. Prior to that the code was too
different for it to be the same patch, and (perhaps not entirely
coincidentally) I had not seen the problems before 9.0. From 9.0
on I have seen multiple sites (all using queuing from Slony or a
JMS implementation) with recurring problems when the queue
temporarily got large, shrank again, and then wrapped around to the
beginning of the table's file space. In some cases performance was
so impaired that when such an event was triggered they would shut
down their application until a manual VACUUM could be run.
--
Kevin Grittner
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
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: kgrittn@ymail.com, scott.marlowe@gmail.com, tgl@sss.pgh.pa.us, mbroers@gmail.com, pgsql-hackers@postgresql.org, JanWieck@yahoo.com
Subject: Re: after 9.2.4 patch vacuumdb -avz not analyzing all tables
In-Reply-To: <1365780972.41333.YahooMailNeo@web162906.mail.bf1.yahoo.com>
* 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