X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 734C153849 for ; Thu, 31 Mar 2005 19:04:19 +0100 (BST) 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 12819-05 for ; Thu, 31 Mar 2005 18:04:05 +0000 (GMT) Received: from floppy.pyrenet.fr (floppy.pyrenet.fr [194.116.145.2]) by svr1.postgresql.org (Postfix) with ESMTP id 286CA537B9 for ; Thu, 31 Mar 2005 19:04:04 +0100 (BST) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id 755F130952; Thu, 31 Mar 2005 20:04:02 +0200 (MET DST) From: Chris Browne X-Newsgroups: pgsql.sql Subject: Re: New record position Date: Thu, 31 Mar 2005 12:33:49 -0500 Organization: cbbrowne Computing Inc Lines: 17 Message-ID: <607jjnsosi.fsf@dba2.int.libertyrms.com> References: <60br90spl0.fsf@dba2.int.libertyrms.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org User-Agent: Gnus/5.1006 (Gnus v5.10.6) XEmacs/21.4 (Jumbo Shrimp, linux) Cancel-Lock: sha1:Hw3z4q6arTHznHENDwwNiQ/Mucs= To: pgsql-sql@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.169 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200503/413 X-Sequence-Number: 20892 gpatnude@hotmail.com ("Greg Patnude") writes: > There's a difference between "natural" order (the location in the > database or on disk) and "record" order (the order specified by the > primary key)... That's well and fine; I could see the "natural order" in which data is returned varying over time in view of the fact that it is probably quickest to start by first returning the rows that are sitting in shared cache, and only then going to the table to get more. -- (format nil "~S@~S" "cbbrowne" "cbbrowne.com") http://www3.sympatico.ca/cbbrowne/postgresql.html "The present need for security products far exceeds the number of individuals capable of designing secure systems. Consequently, industry has resorted to employing folks and purchasing "solutions" from vendors that shouldn't be let near a project involving securing a system." -- Lucky Green