X-Original-To: pgsql-jdbc@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 6948947580B; Mon, 17 Feb 2003 06:23:46 -0500 (EST) Received: from trill.maridan.net (unknown [217.6.52.210]) by postgresql.org (Postfix) with ESMTP id B775B475461; Mon, 17 Feb 2003 06:23:44 -0500 (EST) Received: from polonium.de ([212.121.156.162]) by trill.maridan.net (8.9.3/8.9.3) with ESMTP id MAA32251; Mon, 17 Feb 2003 12:23:46 +0100 Message-ID: <3E50C6A2.2000504@polonium.de> Date: Mon, 17 Feb 2003 12:25:22 +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-performance@postgresql.org Cc: pgsql-jdbc@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> <3E50C071.3090806@klaster.net> In-Reply-To: <3E50C071.3090806@klaster.net> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/243 X-Sequence-Number: 6414 Tomasz Myrta wrote: > 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). fsync is: #fsync = true but there are my new start options: postmaster -i -o -F -D ... after set fsync false I get this Performance for creating new entries with entity beans: needed 9223 for creating 1000 entries instead of about 50.000 milliseconds. it's possible to make it faster? Rafal > Regards, > Tomasz Myrta