Received: from smtpin.superonline.com (stmp2.superonline.com [212.252.115.7] (may be forged)) by hub.org (8.9.3/8.9.3) with ESMTP id GAA61870 for ; Mon, 27 Dec 1999 06:26:32 -0500 (EST) (envelope-from ulu@bornova.ege.edu.tr) Received: from mailsrv.superonline.com (mail.superonline.com [212.252.115.2]) by smtpin.superonline.com (8.9.3/8.9.3) with ESMTP id NAA11704 for ; Mon, 27 Dec 1999 13:28:53 +0200 (EET) Received: from bornova.ege.edu.tr ([212.252.61.217]) by mailsrv.superonline.com (Post.Office MTA v3.5.3 release 223 ID# 635-62499U200000L200000S0V35) with ESMTP id com for ; Mon, 27 Dec 1999 13:29:50 +0200 Sender: root@smtpin.superonline.com Message-ID: <38674FD2.9EFA3A2D@bornova.ege.edu.tr> Date: Mon, 27 Dec 1999 13:38:58 +0200 From: Baris ULU Organization: TEKNOKOM A.S. X-Mailer: Mozilla 4.51 [en] (X11; I; Linux 2.2.5-15 i686) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Performance tuning!!! Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi, I am executing a query from Java and I wait for a long time to gather the results especially for large tables; but when I execute it from the psql prompt it gives me a quick result....Can anyone help me if I can find anything about the performance tuning about the Postgresql6.5.3? My base classes are the JBCL QueryDataSet class to execute the queries...I know this side of the question deals with the Blackdown users bu I gues that the problem is about the backend process.. THANKS Baris ULU Computer Engineer