Skip site navigation (1) Skip section navigation (2)

Re: log_min_duration_statement units

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: PostgreSQL-documentation <pgsql-docs(at)postgresql(dot)org>
Subject: Re: log_min_duration_statement units
Date: 2009-04-06 19:54:43
Message-ID: 200904061954.n36JshH07215@momjian.us (view raw or flat)
Thread:
Lists: pgsql-docs
Tom Lane wrote:
> Bruce Momjian <bruce(at)momjian(dot)us> writes:
> > ! #log_min_duration_statement = -1	# -1 is disabled, 0 logs all statements
>   
> > ! #log_min_duration_statement = -1ms	# -1 is disabled, 0 logs all statements
> 
> This is not sensible -- there are no units for the "-1" setting.  I
> seem to recall that it won't even work; did you test uncommenting that?

I tested it uncommented and manually and it worked fine:

	test=> set log_min_duration_statement = '-1ms';
	SET
	test=> show log_min_duration_statement;
	 log_min_duration_statement
	----------------------------
	 -1
	(1 row)

It seems illogical to document it this way but a non-EDB trainer emailed
me saying students are getting confused about the default units, and I
can see how they would get confused.

-- 
  Bruce Momjian  <bruce(at)momjian(dot)us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

In response to

Responses

pgsql-docs by date

Next:From: Euler Taveira de OliveiraDate: 2009-04-06 19:54:45
Subject: Re: log_min_duration_statement units
Previous:From: Tom LaneDate: 2009-04-06 19:49:01
Subject: Re: log_min_duration_statement units

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group