Re: Table-level log_autovacuum_min_duration

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
Cc: Naoya Anzai <anzai-naoya(at)mxu(dot)nes(dot)nec(dot)co(dot)jp>, PostgreSQL mailing lists <pgsql-hackers(at)postgresql(dot)org>, Akio Iwaasa <iwaasa(at)mxs(dot)nes(dot)nec(dot)co(dot)jp>
Subject: Re: Table-level log_autovacuum_min_duration
Date: 2015-03-05 12:49:03
Message-ID: CAB7nPqQHzimV7DOEuzWnk+ODKLUUsOosXu1xx408zjc3hE44sQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Mar 5, 2015 at 7:10 PM, Fujii Masao wrote:
> With the patch, VACUUM ANALYZE VERBOSE doesn't emit any verbose message.
> Why did you remove that functionality?

Oops. Sorry about that. In gram.y, the combination of VacuumStmt with
AnalyzeStmt overwrote the value of log_min_duration incorrectly. I
also found another bug related to logging of ANALYZE not working
correctly because of the use of IsAutoVacuumWorkerProcess() instead of
VACOPT_VERBOSE (this is reducing the diffs of the patch btw). All
those things are fixed in the attached.
--
Michael

Attachment Content-Type Size
20150305_autovacuum_log_relopts_v9.patch application/x-patch 14.3 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Shigeru Hanada 2015-03-05 13:00:05 Re: Join push-down support for foreign tables
Previous Message Pavel Stehule 2015-03-05 12:46:56 Re: Providing catalog view to pg_hba.conf file - Patch submission