X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id E3987529E2 for ; Tue, 12 Jul 2005 22:05:14 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 58266-06 for ; Wed, 13 Jul 2005 01:05:13 +0000 (GMT) Received: from lakermmtao09.cox.net (lakermmtao09.cox.net [68.230.240.30]) by svr1.postgresql.org (Postfix) with ESMTP id A46C752A0F for ; Tue, 12 Jul 2005 22:05:11 -0300 (ADT) Received: from [127.0.0.1] (really [68.3.22.74]) by lakermmtao09.cox.net (InterMail vM.6.01.04.00 201-2131-118-20041027) with ESMTP id <20050713010513.KULZ15825.lakermmtao09.cox.net@[127.0.0.1]> for ; Tue, 12 Jul 2005 21:05:13 -0400 Message-ID: <42D468C9.9070200@works4me.com> Date: Tue, 12 Jul 2005 18:05:13 -0700 From: Dennis User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: General DB Tuning References: <20050712233230.5466.qmail@web33901.mail.mud.yahoo.com> <42D4621D.4060803@jobflash.com> In-Reply-To: <42D4621D.4060803@jobflash.com> Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 7bit X-Antivirus: avast! (VPS 0528-2, 07/12/2005), Outbound message X-Antivirus-Status: Clean X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200507/129 X-Sequence-Number: 13370 Tom Arthurs wrote: > we are using jdbc -- the "log_min_duration_statement = 3000 " > statement works fine for me. Looks like there's no other work around > for the bug(?). Not sure since I have no interest in logging a > million statements a day, I only want to see the poorly performing hits. Doesn't it depend on what jdbc driver you are using? Dennis