X-Original-To: pgsql-jdbc@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id C313A474E53; Mon, 17 Feb 2003 04:11:09 -0500 (EST) Received: from trill.maridan.net (unknown [217.6.52.210]) by postgresql.org (Postfix) with ESMTP id 4ED6F474E42; Mon, 17 Feb 2003 04:11:08 -0500 (EST) Received: from polonium.de ([212.121.156.162]) by trill.maridan.net (8.9.3/8.9.3) with ESMTP id KAA20972; Mon, 17 Feb 2003 10:11:09 +0100 Message-ID: <3E50A78D.9000806@polonium.de> Date: Mon, 17 Feb 2003 10:12:45 +0100 From: Rafal Kedziorski Organization: POLONIUM User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.2.1) Gecko/20021130 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-jdbc@postgresql.org Cc: pgsql-performance@postgresql.org Subject: Re: Good performance? References: <5.2.0.9.0.20030216232710.01b40810@mail.polonium.de> <3E5068CD.4050909@xythos.com> In-Reply-To: <3E5068CD.4050909@xythos.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/242 X-Sequence-Number: 6413 hi, Barry Lind wrote: > Rafal, > > Performance of postgres running under cygwin isn't great. Can you try > the same test on a different platform? It also looks like you are > running in autocommit mode. You should see a significant performance > improvement if you batch your commits in say groups of 1000 inserts > per commit. after set autocommit false, I need 0,9 - 1,04 seconds for insert 1000 new entries into my table. is this normal, that autocommit false is 40-50 times slower? Rafal > thanks, > --Barry