X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 0846A5285B for ; Sat, 25 Jun 2005 08:44:33 -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 88844-08 for ; Sat, 25 Jun 2005 11:44:28 +0000 (GMT) Received: from www.aldratech.com (www.aldratech.com [193.226.161.42]) by svr1.postgresql.org (Postfix) with ESMTP id 937EC52835 for ; Sat, 25 Jun 2005 08:44:27 -0300 (ADT) Received: by www.aldratech.com (Postfix, from userid 48) id E16D0123F08; Sat, 25 Jun 2005 14:42:44 +0300 (EEST) Received: from 193.138.218.24 (SquirrelMail authenticated user radu.popescu) by www.aldratech.com with HTTP; Sat, 25 Jun 2005 14:42:44 +0300 (EEST) Message-ID: <47992.193.138.218.24.1119699764.squirrel@www.aldratech.com> In-Reply-To: <9be37ba2f850707ad5db17162c56cd64@implements.be> References: <2efd5ae220a4d27b141196b0e7c752e1@implements.be> <9be37ba2f850707ad5db17162c56cd64@implements.be> Date: Sat, 25 Jun 2005 14:42:44 +0300 (EEST) Subject: Re: Speed with offset clause From: "Radu-Adrian Popescu" To: "Yves Vindevogel" Cc: pgsql-performance@postgresql.org Reply-To: radu.popescu@aldratech.com User-Agent: SquirrelMail/1.4.4-1.FC3 MIME-Version: 1.0 Content-Type: text/plain;charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) Importance: Normal X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200506/490 X-Sequence-Number: 13127 > I just ran this query > > select p.* from tblPrintjobs p , (select oid from tblPrintjobs limit 25 > offset 622825) as subset where p.oid = subset.oid > I'm just curious here, from a social point of view. How often do you think someone will paginate over say 300K rows in steps of 25 ? The way I see things, pagination is only meant for humans. If someone really looks at 300K rows then it's really cheaper and makes more sense to download them/import into spreadsheet program instead of clicking next 12.000 times. If it's not intended for humans then there's better ways of doing this. Regards, -- Radu-Adrian Popescu CSA, DBA, Developer Aldrapay MD Aldratech Ltd. +40213212243