Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 955BC2E003A for ; Tue, 12 Feb 2008 16:34:34 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 31163-04 for ; Tue, 12 Feb 2008 16:34:31 -0400 (AST) Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.179]) by postgresql.org (Postfix) with ESMTP id CA9792E0037 for ; Tue, 12 Feb 2008 16:34:30 -0400 (AST) Received: by wa-out-1112.google.com with SMTP id m38so3242481waf.5 for ; Tue, 12 Feb 2008 12:34:29 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=uGI+/SmXDwYWEqw4F+5X3wy+Xp8eO5Yahfn62hTIC8s=; b=GLPWlZHQzGSgEQlZ5p6NJldaadyN5/S60d0SAbLFNcDcl9ovWpKIeVoCmrh26edzZoFfOBg8ztUFuhqv/z1yeGwebzC9FdVoU/8jIG7KCQ160R7zWyUVS4rBRXIfqtcKblx3yqXxf84Z7FG+pBj+lq4ABTmRgi8S6ipfSRvlTlA= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=WcYcFhtOBkviEq7b7kX71L4Vjksqo+ATXBr3po5h7TCAGExd9eATiyZuorjUmCvkSKA85LZYQf4WZLRI18n6riCTjAkisb5pUyPDgnuatNeymkqDECH469lv7Mn0EXK8fwmhJZdkmPvf8dcsf7t3DvTNdfiBGC9EAz/RNT1pdmg= Received: by 10.115.94.1 with SMTP id w1mr1974195wal.85.1202848468768; Tue, 12 Feb 2008 12:34:28 -0800 (PST) Received: by 10.114.199.20 with HTTP; Tue, 12 Feb 2008 12:34:28 -0800 (PST) Message-ID: <4544e0330802121234l33be13a9g5dec39ef032f6268@mail.gmail.com> Date: Tue, 12 Feb 2008 14:34:28 -0600 From: "Peter Koczan" To: "Thomas Zaksek" Subject: Re: Join Query Perfomance Issue Cc: pgsql-performance@postgresql.org In-Reply-To: <47B08F19.8000500@ptt.uni-due.de> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <47B08F19.8000500@ptt.uni-due.de> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/121 X-Sequence-Number: 28663 > I have serious performance problems with the following type of queries: > > Doesnt looks too bad to me, but i'm not that deep into sql query > optimization. However, these type of query is used in a function to > access a normalized, partitioned database, so better performance in this > queries would speed up the whole database system big times. > Any suggestions here would be great. I allready tested some things, > using inner join, rearranging the order of the tables, but but only > minor changes in the runtime, the version above seemed to get us the > best performance. Can you send the table definitions of the tables involved in the query, including index information? Might be if we look hard enough we can find something. Peter