From: Muhammad Alsebaeyie <shipmaster@acm.org>
To: pgsql-interfaces@postgresql.org
Subject: unreasonably slooooow query on small table from JDBC & Zeos
Date: Sat, 14 Oct 2000 19:48:03 +0200
Message-ID: <39E89C52.383C9365@acm.org> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: shipmaster@acm.org
Subject: Re: unreasonably slooooow query on small table from JDBC & Zeos
In-Reply-To: <39E89C52.383C9365@acm.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox