Received: from srvvib02.draexlmaier.de ([193.158.111.132]) by hub.org (8.9.3/8.9.3) with ESMTP id GAA34360 for ; Thu, 25 Nov 1999 06:21:16 -0500 (EST) (envelope-from szuecs.laszlo@draexlmaier.de) Received: from srvvib02.draexlmaier.de (unverified [127.0.0.1]) by srvvib02.draexlmaier.de (Rockliffe SMTPRA 2.1.6) with SMTP id for ; Thu, 25 Nov 1999 12:11:36 +0100 Received: from 157.1.1.111 by srvvib02.draexlmaier.de (InterScan E-Mail VirusWall NT); Thu, 25 Nov 1999 12:11:36 +0100 (W. Europe Standard Time) Received: from draexlmaier.de (STARGATE [157.96.2.99]) by srvvib03.DRAEXLMAIER.DE with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2650.21) id 43QHKLWQ; Thu, 25 Nov 1999 12:20:57 +0100 Sender: root Message-ID: <383D29B6.64EDB4A9@draexlmaier.de> Date: Thu, 25 Nov 1999 13:21:10 +0100 From: Szucs Laszlo X-Mailer: Mozilla 4.7 [en] (X11; I; Linux 2.2.12 i686) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: very slow connection Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Dear List, if I make the following query it takes at least 1-2 min.or dies. The biggest table contains only 150 records and the others do not have more than 10 records. I tried to increase the allocataed memory by -B 1024, but it did not help. Why so slow the connection? Thanks, SzL --------------------------------------- select t0.kostenstelle_id, t0.personalnummer, t2.ausdruck from ma_liste t0,anrede t1,ausdruck t2,erscheinungsbild t3,familienstand t4,funktion t5,kostenstelle t6,orga t7,status t8,umgangsform t9 where (t0.anrede=t1.anrede_id) and (t4.fam_stand_id=t0.fam_stand) and (t0.ersceinungsbild_id=t3.erscheinungsbild_id) and (t0.ausdruck_id=t2.ausdruck_id) and (t0.funktionsid=t5.funktions_id) and (t0.kostenstelle_id=t6.kostenstelle_id) and (t0.umgangsform_id=t9.umgangsform_id) and (t0.status=t8.status_id) and (t0.orga_id=t7.orga_id); ----------------------------------------