Received: from hub.org.org (localhost [127.0.0.1]) by hub.org (8.10.1/8.10.1) with SMTP id e9EIMTr16204 for ; Sat, 14 Oct 2000 14:22:29 -0400 (EDT) Received: from email01.cns-egypt.com (IDENT:root@unassigned.cns-egypt.com [163.121.70.12] (may be forged)) by hub.org (8.10.1/8.10.1) with ESMTP id e9EHpFr03827 for ; Sat, 14 Oct 2000 13:51:16 -0400 (EDT) Received: from acm.org (com070053.cns-egypt.com [163.121.70.53] (may be forged)) by email01.cns-egypt.com (8.9.3/8.9.3) with ESMTP id TAA30202 for ; Sat, 14 Oct 2000 19:12:11 +0200 Message-ID: <39E89C52.383C9365@acm.org> Date: Sat, 14 Oct 2000 19:48:03 +0200 From: Muhammad Alsebaeyie X-Mailer: Mozilla 4.75 [en] (Win98; U) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-interfaces@postgresql.org Subject: unreasonably slooooow query on small table from JDBC & Zeos Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200010/112 X-Sequence-Number: 1469 Hi, I have a small database set up on a local TCP/IP network Linux server, bandwidth is 10 MBit/s. I have a table X of around 6000 records( about 1.5MB) . On querying this table from either JDBC with database pooling or Zeos database explorer (or interactive PGSQL) from a win98 machine,( as simple as select * from X), the query is VERY slow, it may take up to 15 mins. to execute. Eventhough psql executes it in afew seconds, both local from the linux server and using telnet from another machine. I vacuum the database regularly, and I have 2 versions of this table, one with 3 indices and one with only 1 index on the primary key. they both have the same problem. Any Ideas Why this Happens? M. Alsebaeyie