X-Original-To: pgsql-jdbc@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id A33CE475461; Mon, 17 Feb 2003 05:59:32 -0500 (EST) Received: from serwer.skawsoft.com.pl (serwer.skawsoft.com.pl [213.25.37.66]) by postgresql.org (Postfix) with ESMTP id 13D1A474E53; Mon, 17 Feb 2003 05:59:32 -0500 (EST) Received: from klaster.net (pq197.krakow.cvx.ppp.tpnet.pl [213.76.41.197]) by serwer.skawsoft.com.pl (Postfix) with ESMTP id 260802B887; Mon, 17 Feb 2003 11:50:45 +0100 (CET) Message-ID: <3E50C071.3090806@klaster.net> Date: Mon, 17 Feb 2003 11:58:57 +0100 From: Tomasz Myrta User-Agent: Mozilla/5.0 (Windows; U; Win 9x 4.90; PL; rv:1.1) Gecko/20020826 X-Accept-Language: pl, en-us, en MIME-Version: 1.0 To: Rafal Kedziorski Cc: pgsql-jdbc@postgresql.org, pgsql-performance@postgresql.org Subject: Re: [PERFORM] Good performance? References: <5.2.0.9.0.20030216232710.01b40810@mail.polonium.de> <3E5068CD.4050909@xythos.com> <3E50A78D.9000806@polonium.de> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/249 X-Sequence-Number: 6420 Rafal Kedziorski wrote: > 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 It is possible when you have "fsync=false" in your postgresql.conf. (don't change it if you don't have to). Regards, Tomasz Myrta