Re: New record position - Mailing list pgsql-sql

From Chris Browne
Subject Re: New record position
Date
Msg-id 607jjnsosi.fsf@dba2.int.libertyrms.com
Whole thread Raw
In response to Re: New record position  (Chris Browne <cbbrowne@acm.org>)
List pgsql-sql
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


pgsql-sql by date:

Previous
From: "Greg Patnude"
Date:
Subject: Re: New record position
Next
From: "Robin M."
Date:
Subject: unsubscribe pgsql-sql