Re: New record position

Поиск
Список
Период
Сортировка
От Chris Browne
Тема Re: New record position
Дата
Msg-id 607jjnsosi.fsf@dba2.int.libertyrms.com
обсуждение исходный текст
Ответ на Re: New record position  (Chris Browne <cbbrowne@acm.org>)
Список 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 по дате отправления:

Предыдущее
От: "Greg Patnude"
Дата:
Сообщение: Re: New record position
Следующее
От: "Robin M."
Дата:
Сообщение: unsubscribe pgsql-sql