Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id D8EC92E004C for ; Tue, 6 May 2008 13:27:06 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 78077-04 for ; Tue, 6 May 2008 13:27:02 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from relay-1.mail.nethere.net (relay-1.mail.nethere.net [66.63.128.161]) by developer.postgresql.org (Postfix) with ESMTP id CEF7C2E002D for ; Tue, 6 May 2008 13:27:02 -0300 (ADT) Received: from scan-1.mail.nethere.net (scan-1.mail.nethere.net [66.63.128.132]) by relay-1.mail.nethere.net (Postfix) with ESMTP id 28BEE29362; Tue, 6 May 2008 09:27:01 -0700 (PDT) Received: from mta-2.mail.nethere.net by scan-1.mail.nethere.net with LMTP id BS+vC8sEQQyW; Tue, 6 May 2008 09:27:01 -0700 (PDT) Received: from lisa-james-computer.local (wsip-68-224-174-233.sd.sd.cox.net [68.224.174.233]) by mta-2.mail.nethere.net (Postfix) with ESMTP id C7615130C21; Tue, 6 May 2008 09:27:00 -0700 (PDT) Message-ID: <482086D3.3070902@emolecules.com> Date: Tue, 06 May 2008 09:26:59 -0700 From: Craig James User-Agent: Thunderbird 2.0.0.14 (Macintosh/20080421) MIME-Version: 1.0 To: Justin CC: pgsql-performance@postgresql.org Subject: Re: What constitutes a complex query References: <48207D26.7050201@emproshunts.com> In-Reply-To: <48207D26.7050201@emproshunts.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200805/84 X-Sequence-Number: 30052 Justin wrote: > This falls under the stupid question and i'm just curious what other > people think what makes a query complex? There are two kinds: 1. Hard for Postgres to get the answer. 2. Hard for a person to comprehend. Which do you mean? Craig