Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id AEE802E0030 for ; Wed, 20 Feb 2008 07:38:21 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 30258-01-2 for ; Wed, 20 Feb 2008 07:38:10 -0400 (AST) Received: from pih-relay06.plus.net (pih-relay06.plus.net [212.159.14.133]) by postgresql.org (Postfix) with ESMTP id 61AC62E0062 for ; Wed, 20 Feb 2008 07:38:16 -0400 (AST) Received: from [84.51.143.99] (helo=server3.office.archonet.com) by pih-relay06.plus.net with esmtp (Exim) id 1JRnH7-0006ey-J6; Wed, 20 Feb 2008 11:38:09 +0000 Received: from [192.168.1.36] (dell36.office.archonet.com [192.168.1.36]) by server3.office.archonet.com (Postfix) with ESMTP id 1CA0A274059; Wed, 20 Feb 2008 11:38:09 +0000 (GMT) Message-ID: <47BC1121.20800@archonet.com> Date: Wed, 20 Feb 2008 11:38:09 +0000 From: Richard Huxton User-Agent: Thunderbird 2.0.0.9 (X11/20071031) MIME-Version: 1.0 To: shilpa.raghavendra@wipro.com CC: pgsql-performance@postgresql.org Subject: Re: Need Help selecting Large Data From PQSQL References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Plusnet-Relay: f48ff9abfbbc22e38fc98ddc18439cc1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/241 X-Sequence-Number: 28783 shilpa.raghavendra@wipro.com wrote: > The report contains more than 70,000 records but it takes more > than half an hour and some time no result. > > Please help me to generating the report fast. You'll need to provide some more information before anyone can help. Something along the lines of: - table definitions - query definition - EXPLAIN ANALYSE output (or just plain EXPLAIN if that's not practical) -- Richard Huxton Archonet Ltd