Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id D8B659FB68E for ; Sun, 28 Oct 2007 15:22:19 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 65156-06 for ; Sun, 28 Oct 2007 15:22:15 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from mu-out-0910.google.com (mu-out-0910.google.com [209.85.134.187]) by postgresql.org (Postfix) with ESMTP id CEF169F9FDA for ; Sun, 28 Oct 2007 15:22:14 -0300 (ADT) Received: by mu-out-0910.google.com with SMTP id i10so2382806mue for ; Sun, 28 Oct 2007 11:22:13 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding:sender; bh=0g0JRUSLkptMfRyTcw38VBQVN/wRrCbgTdRHQqSnUOI=; b=XDsFTZQkYq3sJfX45A3KbnqM/kiYCCKNSpLtUd4fG5ZfLr0oSOov/eZ2+Mc1mzs7OoYXd1JHX3zRaiGS0kKFyfWZzvJcoVBqUM1v8UXTLkdv95jbNRLpYrljxysPufNt6+P001Z6/hCKP+4S+1XHnyxCQKVyJlembQjr8MnNoeo= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding:sender; b=UDCQKA9oCqLpt/58vPGJ+glkSjtVNe79jHR5lbwTQf0iTeGtzaWkB+pYovgvxPryAteU+/cRqwYi8nTwzP+k5M3NBtPDmYm+xe9eDJuMUnrcEf1M1yAzCzsW+ir6RnU5l+RsD4iIwXaHH54yyj12gnpne/zKxz6F9nd3PM7GqPE= Received: by 10.82.183.19 with SMTP id g19mr10088369buf.1193595733341; Sun, 28 Oct 2007 11:22:13 -0700 (PDT) Received: from ?192.168.1.34? ( [86.27.146.186]) by mx.google.com with ESMTPS id d26sm12315213nfh.2007.10.28.11.22.10 (version=SSLv3 cipher=RC4-MD5); Sun, 28 Oct 2007 11:22:12 -0700 (PDT) Message-ID: <4724D34C.1000606@enterprisedb.com> Date: Sun, 28 Oct 2007 18:22:04 +0000 From: Heikki Linnakangas User-Agent: Icedove 1.5.0.12 (X11/20070730) MIME-Version: 1.0 To: Nimesh Satam CC: pgsql-performance@postgresql.org, nimesh@zedo.com Subject: Re: Append Cost in query planners References: <965aa3ed0710280822x4d1ffc9dh74f67740fdcff5cb@mail.gmail.com> <4724ACE7.4090401@enterprisedb.com> <965aa3ed0710280950p7b931873w213e78f2b170176a@mail.gmail.com> In-Reply-To: <965aa3ed0710280950p7b931873w213e78f2b170176a@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/334 X-Sequence-Number: 27356 Nimesh Satam wrote: > Following is the full plan of the query using partition. Let me know if you > need any further information. What indexes are there on the table partitions? You didn't post the query, but it looks like your doing a join between rpt_network and the partitioned table. An index on the join key might help... -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com