X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id D4E6A11F6B63 for ; Mon, 17 Apr 2006 16:28:43 -0300 (ADT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Score: 0.128 X-Spam-Level: X-Spam-Status: No, score=0.128 required=5 tests=[AWL=0.128] Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id IF34CwPLIfso for ; Mon, 17 Apr 2006 16:28:39 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 9B14811F6B1C for ; Mon, 17 Apr 2006 16:28:40 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id k3HJScrk004410; Mon, 17 Apr 2006 15:28:38 -0400 (EDT) To: "Sriram Dandapani" cc: "Pgsql-Performance \(E-mail\)" Subject: Re: creating of temporary table takes very long In-reply-to: <6992E470F12A444BB787B5C937B9D4DF0406A629@ca-mail1.cis.local> References: <6992E470F12A444BB787B5C937B9D4DF0406A629@ca-mail1.cis.local> Comments: In-reply-to "Sriram Dandapani" message dated "Mon, 17 Apr 2006 11:36:32 -0700" Date: Mon, 17 Apr 2006 15:28:38 -0400 Message-ID: <4409.1145302118@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200604/360 X-Sequence-Number: 18444 "Sriram Dandapani" writes: > [ query snipped ] > This takes forever (I have to cancel the statement each time) How long did you wait? > c_chkpfw_hr_tr has same indexes as chkpfw_tr_hr_dimension Which would be what exactly? What does EXPLAIN show for that SELECT? (I won't make you post EXPLAIN ANALYZE, if you haven't got the patience to let it finish, but you should at least provide EXPLAIN results.) regards, tom lane