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 E81AA5281B for ; Tue, 12 Jul 2005 22:30:29 -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 60646-10 for ; Wed, 13 Jul 2005 01:30:21 +0000 (GMT) Received: from mail.jobflash.com (oncallweb2.jobflash.com [64.62.211.41]) by svr1.postgresql.org (Postfix) with ESMTP id 216EC529C2 for ; Tue, 12 Jul 2005 22:30:20 -0300 (ADT) Received: from [192.168.2.22] (user-38lc18a.dialup.mindspring.com [209.86.5.10]) by mail.jobflash.com (Postfix) with ESMTP id 49003420CF; Tue, 12 Jul 2005 18:30:24 -0700 (PDT) Message-ID: <42D46EA6.605@jobflash.com> Date: Tue, 12 Jul 2005 18:30:14 -0700 From: Tom Arthurs User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Dennis Cc: pgsql-performance@postgresql.org Subject: Re: General DB Tuning References: <20050712233230.5466.qmail@web33901.mail.mud.yahoo.com> <42D4621D.4060803@jobflash.com> <42D468C9.9070200@works4me.com> In-Reply-To: <42D468C9.9070200@works4me.com> Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 7bit 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/131 X-Sequence-Number: 13372 hmm, yea maybe -- we are using the 7.4 driver with 8.0.x db. Dennis wrote: > 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 > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster > > >