Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id C3CD716FA502 for ; Mon, 9 Jul 2012 14:46:55 -0300 (ADT) Received: from relay3-d.mail.gandi.net ([217.70.183.195]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SoI2v-000282-M1 for pgsql-performance@postgresql.org; Mon, 09 Jul 2012 17:46:54 +0000 X-Originating-IP: 217.70.178.143 Received: from mfilter15-d.gandi.net (mfilter15-d.gandi.net [217.70.178.143]) by relay3-d.mail.gandi.net (Postfix) with ESMTP id 79E99A8073 for ; Mon, 9 Jul 2012 19:46:29 +0200 (CEST) X-Virus-Scanned: Debian amavisd-new at mfilter15-d.gandi.net Received: from relay3-d.mail.gandi.net ([217.70.183.195]) by mfilter15-d.gandi.net (mfilter15-d.gandi.net [10.0.15.180]) (amavisd-new, port 10024) with ESMTP id FVSc2bUSl0kl for ; Mon, 9 Jul 2012 19:46:28 +0200 (CEST) X-Originating-IP: 98.27.54.176 Received: from [192.168.10.146] (cpe-098-027-054-176.nc.res.rr.com [98.27.54.176]) (Authenticated sender: adsend@dunslane.net) by relay3-d.mail.gandi.net (Postfix) with ESMTPSA id AFB1EA80A7 for ; Mon, 9 Jul 2012 19:46:27 +0200 (CEST) Message-ID: <4FFB18F2.7010002@dunslane.net> Date: Mon, 09 Jul 2012 13:46:26 -0400 From: Andrew Dunstan User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:13.0) Gecko/20120605 Thunderbird/13.0 MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: Paged Query References: <4FF43638.5080301@web.de> In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -2.6 (--) X-Archive-Number: 201207/98 X-Sequence-Number: 47279 On 07/09/2012 01:41 PM, Misa Simic wrote: > > > From my experience users even very rare go to ending pages... easier > to them would be to sort data by field to get those rows in very first > pages... > > Yeah, the problem really is that most client code wants to know how many pages there are, even if it only wants one page right now. cheers andrew