Re: return records in DB load order??

Поиск
Список
Период
Сортировка
От Maksim Likharev
Тема Re: return records in DB load order??
Дата
Msg-id 56510AAEF435D240958D1CE8C6B1770A016D2D3E@mailc03.aurigin.com
обсуждение исходный текст
Ответ на return records in DB load order??  ("Maksim Likharev" <mlikharev@aurigin.com>)
Список pgsql-general
It is 32 bit, but discussion slept into different direction,

so really I have freshly loaded DB where present set of 2 tables,
one [to] many, where many has a primary record, of cause without
indication
that is primary but ancient knowledge exists that primary record was
first during a DB load.
In order to fix that, I just want to use oid as indication of first in
order,
and I guess that's will work.



-----Original Message-----
From: weigelt@metux.de [mailto:weigelt@metux.de]
Sent: Friday, June 13, 2003 1:49 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] return records in DB load order??


On Fri, Jun 13, 2003 at 01:36:46PM -0700, Dann Corbit wrote:

<snip>
> What happens when you have 2^32 + 1 rows in a table?  A 4 byte OID
> cannot contain it.
Isnt the oid type now 64 bits wide ?

cu
--
---------------------------------------------------------------------
 Enrico Weigelt    ==   metux ITS
 Webhosting ab 5 EUR/Monat.          UUCP, rawIP und vieles mehr.

 phone:     +49 36207 519931         www:       http://www.metux.de/

 fax:       +49 36207 519932         email:     contact@metux.de
 cellphone: +49 174 7066481         smsgate:   sms.weigelt@metux.de
---------------------------------------------------------------------
 Diese Mail wurde mit UUCP versandt.      http://www.metux.de/uucp/

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

В списке pgsql-general по дате отправления:

Предыдущее
От: Ernest E Vogelsinger
Дата:
Сообщение: Re: Postgres performance comments from a MySQL user
Следующее
От: Bruno Wolff III
Дата:
Сообщение: Re: using sequences