X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 0035BDB00B
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Wed, 26 Oct 2005 22:44:44 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 90927-01
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Thu, 27 Oct 2005 01:44:40 +0000 (GMT)
Received: from houston.familyhealth.com.au (houston.au.fhnetwork.com
	[203.22.197.21])
	by svr1.postgresql.org (Postfix) with ESMTP id AE654DB007
	for <pgsql-performance@postgresql.org>;
	Wed, 26 Oct 2005 22:44:42 -0300 (ADT)
Received: from houston.familyhealth.com.au (localhost [127.0.0.1])
	by houston.familyhealth.com.au (Postfix) with ESMTP id C154C25074;
	Thu, 27 Oct 2005 09:44:46 +0800 (WST)
Received: from [127.0.0.1] (work-40.internal [192.168.0.40])
	by houston.familyhealth.com.au (Postfix) with ESMTP id 7DF6425072;
	Thu, 27 Oct 2005 09:44:44 +0800 (WST)
Message-ID: <43603166.40705@familyhealth.com.au>
Date: Thu, 27 Oct 2005 09:46:14 +0800
From: Christopher Kings-Lynne <chriskl@familyhealth.com.au>
User-Agent: Mozilla Thunderbird 1.0.7 (Windows/20050923)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: PFC <lists@boutiquenumerique.com>
Cc: aurora <aurora00@gmail.com>, pgsql-performance@postgresql.org
Subject: Re: browsing table with 2 million records
References: <cbd177510510261341l4ed7a214lda9d67af12f2ec21@mail.gmail.com>
	<op.sy9v9gketh1vuj@localhost>
In-Reply-To: <op.sy9v9gketh1vuj@localhost>
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 7bit
X-familyhealth-MailScanner-Information: Please contact the ISP for more
	information
X-familyhealth-MailScanner: Found to be clean
X-familyhealth-MailScanner-From: chriskl@familyhealth.com.au
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.06 required=5 tests=[AWL=0.010,
	FORGED_RCVD_HELO=0.05]
X-Spam-Level: 
X-Archive-Number: 200510/409
X-Sequence-Number: 15177

>     Who needs a paginated view with 100.000 pages ?
> 
>     - Select min(date) and max(date) from your table
>     - Present a nifty date selector to choose the records from any day, 
> hour,  minute, second
>     - show them, with "next day" and "previous day" buttons
> 
>     - It's more useful to the user (most likely he wants to know what  
> happened on 01/05/2005 rather than view page 2857)
>     - It's faster (no more limit/offset ! just "date BETWEEN a AND b",  
> indexed of course)
>     - no more new items pushing old ones to the next page while you browse
>     - you can pretend to your boss it's just like a paginated list

All very well and good, but now do it generically...