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 CC13E11F6B03 for ; Thu, 20 Apr 2006 03:27:36 -0300 (ADT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Score: 0.08 X-Spam-Level: X-Spam-Status: No, score=0.08 required=5 tests=[AWL=0.080] Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 7uVowIpFixn5 for ; Thu, 20 Apr 2006 03:27:31 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from wolff.to (wolff.to [66.93.197.194]) by postgresql.org (Postfix) with SMTP id 40E7111F6AB2 for ; Thu, 20 Apr 2006 03:27:31 -0300 (ADT) Received: (qmail 25526 invoked by uid 500); 20 Apr 2006 06:30:14 -0000 Date: Thu, 20 Apr 2006 01:30:14 -0500 From: Bruno Wolff III To: soni de Cc: Merlin Moncure , pgsql-performance@postgresql.org Subject: Re: Takes too long to fetch the data from database Message-ID: <20060420063014.GA25438@wolff.to> Mail-Followup-To: Bruno Wolff III , soni de , Merlin Moncure , pgsql-performance@postgresql.org References: <9f2e40a90604100021n1cb694d0lb95f318f800f33ee@mail.gmail.com> <9f2e40a90604110004u787716c2s22bdf53fe349326@mail.gmail.com> <9f2e40a90604192237i5d3e8f0dl1c8b19887bc34e22@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <9f2e40a90604192237i5d3e8f0dl1c8b19887bc34e22@mail.gmail.com> User-Agent: Mutt/1.4.2.1i X-Archive-Number: 200604/437 X-Sequence-Number: 18521 On Thu, Apr 20, 2006 at 11:07:31 +0530, soni de wrote: > Please provide me some help regarding how could I use cursor in following > cases? : > > I want to fetch 50 records at a time starting from largest stime. > > SELECT * FROM wan ORDER BY stime LIMIT 50 OFFSET 81900; Something like the following may be faster: SELECT * FROM wan ORDER BY stime DESC LIMIT 50;