From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
---|---|
To: | Kevin Grittner <kgrittn(at)ymail(dot)com> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Mike Broers <mbroers(at)gmail(dot)com>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>, Jan Wieck <JanWieck(at)yahoo(dot)com> |
Subject: | Re: after 9.2.4 patch vacuumdb -avz not analyzing all tables |
Date: | 2013-04-12 14:48:30 |
Message-ID: | CAOR=d=2sAp5YwXQ6i5361jNeh51jqtg-2GYUJe6bgeT2Y_+QxA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-hackers |
Does this behavior only affect the 9.2 branch? Or was it ported to 9.1 or
9.0 or 8.4 as well?
On Thu, Apr 11, 2013 at 7:48 PM, Kevin Grittner <kgrittn(at)ymail(dot)com> wrote:
> Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> > However I've got to say that both of those side-effects of
> > exclusive-lock abandonment seem absolutely brain dead now that I
> > see them. Why would we not bother to tell the stats collector
> > what we've done? Why would we think we should not do ANALYZE
> > when we were told to?
> >
> > Would someone care to step forward and defend this behavior?
> > Because it's not going to be there very long otherwise.
>
> I'm pretty sure that nobody involved noticed the impact on VACUUM
> ANALYZE command; all discussion was around autovacuum impact; and
> Jan argued that this was leaving things in a status quo for that,
> so I conceded the point and left it for a follow-on patch if
> someone felt the behavior needed to change. Sorry for the miss.
>
> http://www.postgresql.org/message-id/50BB700E.8060404@Yahoo.com
>
> As far as I'm concerned all effects on the explicit command were
> unintended and should be reverted.
>
> --
> Kevin Grittner
> EnterpriseDB: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
--
To understand recursion, one must first understand recursion.
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Grittner | 2013-04-12 15:36:12 | Re: after 9.2.4 patch vacuumdb -avz not analyzing all tables |
Previous Message | Mike Broers | 2013-04-12 14:10:53 | Re: [ADMIN] after 9.2.4 patch vacuumdb -avz not analyzing all tables |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2013-04-12 14:58:13 | Re: Analyzing bug 8049 |
Previous Message | Robert Haas | 2013-04-12 14:45:19 | Re: [sepgsql 2/3] Add db_schema:search permission checks |