From:
Robert Haas <robertmhaas(at)gmail(dot)com>
To:
Cédric Villemain <cedric(dot)villemain(dot)debian(at)gmail(dot)com>
Cc:
Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Simon Riggs <simon(at)2ndquadrant(dot)com>, Josh Berkus <josh(at)agliodbs(dot)com>, Greg Smith <greg(at)2ndquadrant(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject:
Re: We need to log aborted autovacuums
Date:
2011-02-05 20:25:19
Message-ID:
AANLkTinqqHd-iOvxyPFBZkHDG7yb_4aZ846hDxgcrEeP@mail.gmail.com (view raw or flat )
Thread:
2010-11-17 21:46:21 from Josh Berkus <josh(at)agliodbs(dot)com>
2010-11-17 21:55:40 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
2010-11-17 22:50:49 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-11-17 23:31:44 from Josh Berkus <josh(at)agliodbs(dot)com>
2010-11-17 23:35:45 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-11-17 23:49:24 from Itagaki Takahiro <itagaki(dot)takahiro(at)gmail(dot)com>
2010-11-17 23:52:47 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2011-01-05 06:55:02 from Greg Smith <greg(at)2ndquadrant(dot)com>
2011-01-05 12:29:39 from Magnus Hagander <magnus(at)hagander(dot)net>
2011-01-05 19:27:10 from Josh Berkus <josh(at)agliodbs(dot)com>
2011-01-05 22:56:51 from Robert Treat <rob(at)xzilla(dot)net>
2011-01-05 23:06:11 from Josh Berkus <josh(at)agliodbs(dot)com>
2011-01-07 04:11:36 from Greg Smith <greg(at)2ndquadrant(dot)com>
2011-01-07 04:33:23 from Greg Smith <greg(at)2ndquadrant(dot)com>
2011-01-07 19:00:20 from Josh Berkus <josh(at)agliodbs(dot)com>
2011-01-08 01:15:12 from Greg Smith <greg(at)2ndquadrant(dot)com>
2011-01-08 06:05:20 from David Fetter <david(at)fetter(dot)org>
2011-01-08 12:17:51 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2011-01-15 09:47:56 from Greg Smith <greg(at)2ndquadrant(dot)com>
2011-01-15 16:14:12 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2011-01-15 19:29:54 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-01-16 16:23:16 from Greg Smith <greg(at)2ndquadrant(dot)com>
2011-01-16 16:47:35 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2011-01-16 17:18:22 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2011-01-16 18:08:03 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2011-01-16 18:08:36 from Greg Smith <greg(at)2ndquadrant(dot)com>
2011-01-16 18:20:54 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2011-01-16 19:19:47 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2011-01-16 20:50:08 from Josh Berkus <josh(at)agliodbs(dot)com>
2011-01-17 01:36:32 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2011-01-17 01:50:49 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-01-17 19:46:33 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2011-01-17 20:24:30 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2011-01-17 21:08:12 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2011-01-31 02:37:51 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-01-31 03:03:19 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2011-01-31 03:26:01 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-02-04 03:49:20 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-02-04 12:08:58 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-02-05 17:54:28 from Cédric Villemain <cedric(dot)villemain(dot)debian(at)gmail(dot)com>
2011-02-05 18:40:08 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-02-05 20:20:57 from Cédric Villemain <cedric(dot)villemain(dot)debian(at)gmail(dot)com>
2011-02-05 20:25:19 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-02-05 20:34:15 from Cédric Villemain <cedric(dot)villemain(dot)debian(at)gmail(dot)com>
2011-02-08 03:05:21 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-01-18 01:26:09 from Josh Berkus <josh(at)agliodbs(dot)com>
2011-01-18 02:12:13 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-01-18 03:04:08 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2011-01-18 06:41:29 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2011-01-16 18:22:38 from Greg Smith <greg(at)2ndquadrant(dot)com>
2011-01-16 18:26:38 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Lists:
pgsql-hackers
On Sat, Feb 5, 2011 at 3:20 PM, Cédric Villemain
<cedric(dot)villemain(dot)debian(at)gmail(dot)com> wrote:
>> In the case where a table is skipped for this reason, we log a message
>> at log level LOG. The version of the patch I posted does that
>> unconditionally, but my intention was to change it before commit so
>> that it only logs the message if log_autovacuum_min_duration is
>> something other than -1.
>
> yes looks better, I also note that someone suggest to not add a GUC for that.
I think a GUC just to control this one message is overkill. Chances
are that if you're logging some or all of your autovacuum runs you'll
want to have this too, or at least it won't be a major problem to get
it anyway. If for some reason you want ONLY this message, you can
effectively get that behavior too, but setting
log_autovacuum_min_duration to an enormous value. So I can't really
imagine why you'd need a separate knob just for this one thing.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
In response to
Responses
pgsql-hackers by date
Next :From: Cédric VillemainDate: 2011-02-05 20:34:15Subject : Re: We need to log aborted autovacuumsPrevious :From : Cédric VillemainDate : 2011-02-05 20:20:57Subject : Re: We need to log aborted autovacuums
