Received: from sss.pgh.pa.us ([192.204.191.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fBIFbHm90119 for ; Tue, 18 Dec 2001 10:37:17 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.4/8.11.4) with ESMTP id fBIFasi13427; Tue, 18 Dec 2001 10:36:54 -0500 (EST) To: Archibald Zimonyi cc: postgres sql list Subject: Re: Performance problem, what to do? In-reply-to: References: Comments: In-reply-to Archibald Zimonyi message dated "Tue, 18 Dec 2001 14:32:07 +0100" Date: Tue, 18 Dec 2001 10:36:54 -0500 Message-ID: <13424.1008689814@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200112/200 X-Sequence-Number: 6023 Archibald Zimonyi writes: > On demand, I'll post the database structure as well as the SQL query which > creates the slow respons. I'll add them as attachments (do they come at > all?). You're forcing the join order by using explicit JOIN syntax. Rearranging the join order might yield a better plan. See http://www.postgresql.org/users-lounge/docs/7.1/postgres/explicit-joins.html regards, tom lane