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 83F1E56445 for ; Tue, 15 Mar 2005 23:51:20 +0000 (GMT) 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 70398-04 for ; Tue, 15 Mar 2005 23:51:18 +0000 (GMT) Received: from tht.net (vista.tht.net [216.126.88.2]) by svr1.postgresql.org (Postfix) with ESMTP id 210FA563FB for ; Tue, 15 Mar 2005 23:51:17 +0000 (GMT) Received: from dyn-70-66.tor.dsl.tht.net (dyn-70-66.tor.dsl.tht.net [134.22.70.66]) by tht.net (Postfix) with ESMTP id 8931276A8A; Tue, 15 Mar 2005 18:51:18 -0500 (EST) Subject: Re: Performance problem on delete from for 10k rows. From: Rod Taylor To: David Gagnon Cc: pgsql-performance@postgresql.org In-Reply-To: <42375281.9090102@siunik.com> References: <42375281.9090102@siunik.com> Content-Type: text/plain Date: Tue, 15 Mar 2005 18:50:27 -0500 Message-Id: <1110930627.1132.196.camel@home> Mime-Version: 1.0 X-Mailer: Evolution 2.2.0 FreeBSD GNOME Team Port Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.013 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200503/311 X-Sequence-Number: 11016 > I get this problem on my dev (Windows/7.4/Cygwin) environment. But now > I see that it's also have this problem on my production env. Yes I > tought I was maybe just a cygwin/Windows problem .. apparently not :-(((( Care to try again with logging enabled on the PostgreSQL side within the development environment? log_statement = true log_duration = true log_connections = on Then run it via Java and from pgAdminIII and send us the two log snippets as attachments? Thanks. --