X-Original-To: pgsql-performance@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 8A9D5475A7F; Mon, 17 Feb 2003 07:26:24 -0500 (EST) Received: from grunt21.ihug.com.au (grunt21.ihug.com.au [203.109.249.141]) by postgresql.org (Postfix) with ESMTP id C3663475A5C; Mon, 17 Feb 2003 07:26:23 -0500 (EST) Received: from p341-tnt1.adl.ihug.com.au (postgresql.org) [203.173.255.87] by grunt21.ihug.com.au with esmtp (Exim 3.35 #1 (Debian)) id 18kkLo-0001mB-00; Mon, 17 Feb 2003 23:26:24 +1100 Message-ID: <3E50D539.8030501@postgresql.org> Date: Mon, 17 Feb 2003 22:57:37 +1030 From: Justin Clift 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: Rafal Kedziorski Cc: pgsql-performance@postgresql.org, pgsql-jdbc@postgresql.org Subject: Re: [JDBC] 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> <3E50C6A2.2000504@polonium.de> In-Reply-To: <3E50C6A2.2000504@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/107 X-Sequence-Number: 1163 Rafal Kedziorski wrote: > instead of about 50.000 milliseconds. it's possible to make it faster? Hi Rafal, Have you tuned the memory settings of PostgreSQL yet? Regards and best wishes, Justin Clift > Rafal -- "My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there." - Indira Gandhi