Received: from apas.mandanet.ch (IDENT:qmailr@apas.mandanet.ch [195.15.14.73]) by hub.org (8.9.3/8.9.3) with SMTP id KAA45921 for ; Wed, 14 Jul 1999 10:32:19 -0400 (EDT) (envelope-from jknobl@mandanet.ch) Received: (qmail 17416 invoked from network); 14 Jul 1999 14:31:09 -0000 Received: from apas.mandanet.ch (HELO mandanet.ch) (jknobl@195.15.14.73) by apas.mandanet.ch with SMTP; 14 Jul 1999 14:31:09 -0000 Sender: jknobl Message-ID: <378C9F2D.495FB4A0@mandanet.ch> Date: Wed, 14 Jul 1999 14:31:09 +0000 From: =?iso-8859-1?Q?J=E9rome=20Kn=F6bl?= Organization: Novasys X-Mailer: Mozilla 4.5 [en] (X11; I; Linux 2.0.35 i586) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@hub.org Subject: Prolem wiht long query? Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Hi, I have some trouble with a very long query. This Query run well : ---------------- select * from adresses, liaison_adresse_rubrique as lar0, liaison_adresse_rubrique as lar1, liaison_adresse_rubrique as lar2 where lar0.refadresse=adresses.ref and lar0.refrubrique=73 and lar1.refadresse=adresses.ref and lar1.refrubrique=151 and lar2.refadresse=adresses.ref and lar2.refrubrique=170 This Query take a lot of time : ----------------------- select * from adresses, liaison_adresse_rubrique as lar0, liaison_adresse_rubrique as lar1, liaison_adresse_rubrique as lar2, liaison_adresse_rubrique as lar3, liaison_adresse_rubrique as lar4 where lar0.refadresse=adresses.ref and lar0.refrubrique=73 and lar1.refadresse=adresses.ref and lar1.refrubrique=150 and lar2.refadresse=adresses.ref and lar2.refrubrique=160 and lar3.refadresse=adresses.ref and lar3.refrubrique=151 and lar4.refadresse=adresses.ref and lar4.refrubrique=170 This Query never finish, and take all my memory (and I have 384Mb) --------------------------------------------------- select * from adresses, liaison_adresse_rubrique as lar0, liaison_adresse_rubrique as lar1, liaison_adresse_rubrique as lar2, liaison_adresse_rubrique as lar3, liaison_adresse_rubrique as lar4, liaison_adresse_rubrique as lar5, liaison_adresse_rubrique as lar6 where lar0.refadresse=adresses.ref and lar0.refrubrique=73 and lar1.refadresse=adresses.ref and lar1.refrubrique=148 and lar2.refadresse=adresses.ref and lar2.refrubrique=153 and lar3.refadresse=adresses.ref and lar3.refrubrique=150 and lar4.refadresse=adresses.ref and lar4.refrubrique=160 and lar5.refadresse=adresses.ref and lar5.refrubrique=151 and lar6.refadresse=adresses.ref and lar6.refrubrique=170 Every think is index using hash table. Is it a limitation of pg? Do you know another method to do that? Is it exist an intersect operator in pg (like in oracle)? Jérome knobl, Lausanne, Switzerland