Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 9A6982E0072 for ; Tue, 6 May 2008 14:23:11 -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 96552-04-3 for ; Tue, 6 May 2008 14:23:04 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from mail.emproshunts.com (mail.emproshunts.com [66.64.191.19]) by developer.postgresql.org (Postfix) with ESMTP id EDB162E004D for ; Tue, 6 May 2008 14:23:02 -0300 (ADT) Received: from [192.168.1.49] by mail.emproshunts.com (GMS 15.00.3626/KX5895.00.ca7cb0e7) with ESMTP id huamhaaa for pgsql-performance@postgresql.org; Tue, 6 May 2008 13:23:02 -0400 Message-ID: <482093F4.2030801@emproshunts.com> Date: Tue, 06 May 2008 12:23:00 -0500 From: Justin User-Agent: Thunderbird 2.0.0.14 (Windows/20080421) MIME-Version: 1.0 To: Craig James CC: pgsql-performance@postgresql.org Subject: Re: What constitutes a complex query References: <48207D26.7050201@emproshunts.com> <482086D3.3070902@emolecules.com> In-Reply-To: <482086D3.3070902@emolecules.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Originating-IP: [192.168.1.49] X-DNSBL: 0 X-AntiSpam: Checked for restricted content by Gordano's AntiSpam Software X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200805/94 X-Sequence-Number: 30062 Craig James wrote: > 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. this one > > 2. Hard for a person to comprehend. > > Which do you mean? > > Craig >