pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / color / mirror / Atom feed
From: Chris Browne <cbbrowne@acm.org>
To: pgsql-sql@postgresql.org
Subject: Re: New record position
Date: Thu, 31 Mar 2005 12:33:49 -0500
Message-ID: <607jjnsosi.fsf@dba2.int.libertyrms.com> (raw)
References: <60br90spl0.fsf@dba2.int.libertyrms.com>
<BAY14-DAV12DCBD187D6EAEDE838034D7470@phx.gbl>
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
view thread (7+ messages)
Message-ID: <607jjnsosi.fsf@dba2.int.libertyrms.com> Permalink: ../607jjnsosi.fsf@dba2.int.libertyrms.com/ Also on: postgresql.org/message-id/607jjnsosi.fsf@dba2.int.libertyrms.com ·
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-sql@postgresql.org Cc: cbbrowne@acm.org Subject: Re: New record position In-Reply-To: <607jjnsosi.fsf@dba2.int.libertyrms.com> * 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