From: Franz J Fortuny <ffortuny@ivsol.com>
To: pgSQL <pgsql-sql@postgresql.org>
Subject: Speed or configuration
Date: Sun, 20 Aug 2000 11:05:24 -0500
Message-ID: <010501c00ac0$72d47a20$0b01a8c0@ivsol> (raw)
At our company we are presently using a commercial
database that generates results from this query:
select xx1,xx2,xx3 from tableX
where field1 in
(select field1 from tableY where
field2=NNN and field3=NNN2 and field4=NNN4)
tableX has 790,000 rows, and an index on field1
tableY has abou 175,000 rows and an index that includes
field2,field3,field4 (and 2 other fields not being used
here)
Of course, the order in the indexes is the logical one.
I have made copies of the tables from the commercial SQL
server to PostgreSQL and PostgreSQL is consistently
faster in things like count(*) and certain other
queries.
But when it comes to the above mentioned query,
PostgreSQL simply stays there, forever. The postgres
backend must be killed in order to free the client
program.
Any suggestions?
Franz J Fortuny
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: ffortuny@ivsol.com
Subject: Re: Speed or configuration
In-Reply-To: <010501c00ac0$72d47a20$0b01a8c0@ivsol>
References: <010501c00ac0$72d47a20$0b01a8c0@ivsol>
* 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