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 8974111F8D3B for ; Mon, 10 Apr 2006 16:40:15 -0300 (ADT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Score: 0.12 X-Spam-Level: X-Spam-Status: No, score=0.12 required=5 tests=[AWL=0.120] Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id fYdN+FL9TIDV for ; Mon, 10 Apr 2006 16:38:07 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from projects.commandprompt.com (host-130.commandprompt.net [207.173.203.130]) by postgresql.org (Postfix) with ESMTP id CBE9A11F8D48 for ; Mon, 10 Apr 2006 15:20:09 -0300 (ADT) Received: from [192.168.15.100] (or-67-76-146-141.sta.sprint-hsd.net [67.76.146.141]) (authenticated bits=0) by projects.commandprompt.com (8.13.4/8.13.4) with ESMTP id k3AIK7oi016902; Mon, 10 Apr 2006 11:20:07 -0700 Message-ID: <443AA1D4.9010308@commandprompt.com> Date: Mon, 10 Apr 2006 11:20:04 -0700 From: "Joshua D. Drake" Organization: Command Prompt, Inc. User-Agent: Mail/News 1.5 (X11/20060309) MIME-Version: 1.0 To: Rajesh Kumar Mallah CC: soni de , pgsql-performance@postgresql.org Subject: Re: Takes too long to fetch the data from database References: <9f2e40a90604100021n1cb694d0lb95f318f800f33ee@mail.gmail.com> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: ClamAV version 0.88, clamav-milter version 0.87 on projects.commandprompt.com X-Virus-Status: Clean X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by milter-greylist-1.6 (projects.commandprompt.com [192.168.2.159]); Mon, 10 Apr 2006 11:20:08 -0700 (PDT) X-Archive-Number: 200604/214 X-Sequence-Number: 18298 Rajesh Kumar Mallah wrote: > > what is the query ? > use LIMIT or a restricting where clause. You could also use a cursor. Joshua D. Drake > > > regds > mallah. > > On 4/10/06, *soni de* < soni.de@gmail.com > wrote: > > Hello, > > I have difficulty in fetching the records from the database. > Database table contains more than 1 GB data. > For fetching the records it is taking more the 1 hour and that's why > it is slowing down the performance. > please provide some help regarding improving the performance and how > do I run query so that records will be fetched in a less time. > > -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/