pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Andrew Dunstan <andrew@dunslane.net>
To: pgsql-performance@postgresql.org
Subject: Re: Paged Query
Date: Mon, 09 Jul 2012 13:46:26 -0400
Message-ID: <4FFB18F2.7010002@dunslane.net> (raw)
In-Reply-To: <CAH3i69makOWwAioB=v=uOLQ=bwMV+F+=+sjdwDW3H2qfhb-SUg@mail.gmail.com>
References: <4FF43638.5080301@web.de>
	<CAH3i69=B7VPj0rkbuxv9TLEF6V0DjB2xzcEUkf8U7BYULCOBug@mail.gmail.com>
	<CAJY59_icde+87mo65fJT8v9GdOTFemQFMNg5mxy52GCgjVe85w@mail.gmail.com>
	<CAH3i69makOWwAioB=v=uOLQ=bwMV+F+=+sjdwDW3H2qfhb-SUg@mail.gmail.com>


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



view thread (19+ messages)  latest in thread

Message-ID: <4FFB18F2.7010002@dunslane.net>
Permalink:  ../4FFB18F2.7010002@dunslane.net/
Also on:    postgresql.org/message-id/4FFB18F2.7010002@dunslane.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: andrew@dunslane.net
  Subject: Re: Paged Query
  In-Reply-To: <4FFB18F2.7010002@dunslane.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox