Skip site navigation (1) Skip section navigation (2)

Speed or configuration

From: "Franz J Fortuny" <ffortuny(at)ivsol(dot)com>
To: "pgSQL" <pgsql-sql(at)postgresql(dot)org>
Subject: Speed or configuration
Date: 2000-08-20 16:05:24
Message-ID: 010501c00ac0$72d47a20$0b01a8c0@ivsol (view raw, whole thread or download thread mbox)
Lists: pgsql-sql
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

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

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

Any suggestions?

Franz J Fortuny


pgsql-sql by date

Next:From: Louis-David MitterrandDate: 2000-08-20 16:29:33
Subject: protecting a field after creation
Previous:From: Marc RoosDate: 2000-08-20 11:57:29
Subject: datatype SET

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group