Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id D27389FB7FC for ; Tue, 3 Apr 2007 03:14:38 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 46211-04 for ; Tue, 3 Apr 2007 03:14:36 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by postgresql.org (Postfix) with SMTP id BDEFB9FB7C3 for ; Tue, 3 Apr 2007 03:14:37 -0300 (ADT) Received: (qmail invoked by alias); 03 Apr 2007 06:14:36 -0000 Received: from xdsl-87-78-210-204.netcologne.de (EHLO colt.pezone.net) [87.78.210.204] by mail.gmx.net (mp035) with SMTP; 03 Apr 2007 08:14:36 +0200 X-Authenticated: #495269 X-Provags-ID: V01U2FsdGVkX18lqpRsGzgl8g8DfLyOX0u73S3rDZ3OJd1BXffdar gCddn0ynVuM1yg From: Peter Eisentraut To: pgsql-patches@postgresql.org Subject: Re: Logging checkpoints and other slowdown causes Date: Tue, 3 Apr 2007 08:14:33 +0200 User-Agent: KMail/1.9.5 Cc: Greg Smith References: In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200704030814.33999.peter_e@gmx.net> X-Y-GMX-Trusted: 0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/81 X-Sequence-Number: 1648 Greg Smith wrote: > This patch puts entries in the log file around some backend events > that regularly cause client pauses, most of which are visible only > when running with log_min_messages = debug2. Something that is aimed at a user should not be enabled at a "debug" level. Debug levels are for debugging, not for very high verbosity. -- Peter Eisentraut http://developer.postgresql.org/~petere/