From: | "Maksim Likharev" <mlikharev(at)aurigin(dot)com> |
---|---|
To: | <weigelt(at)metux(dot)de>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: return records in DB load order?? |
Date: | 2003-06-13 21:05:38 |
Message-ID: | 56510AAEF435D240958D1CE8C6B1770A016D2D3E@mailc03.aurigin.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)metux(dot)de [mailto:weigelt(at)metux(dot)de]
Sent: Friday, June 13, 2003 1:49 PM
To: pgsql-general(at)postgresql(dot)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(at)metux(dot)de
cellphone: +49 174 7066481 smsgate: sms(dot)weigelt(at)metux(dot)de
---------------------------------------------------------------------
Diese Mail wurde mit UUCP versandt. http://www.metux.de/uucp/
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
From | Date | Subject | |
---|---|---|---|
Next Message | The Hermit Hacker | 2003-06-13 21:06:10 | Re: [HACKERS] SAP and MySQL ... [and Benchmark] |
Previous Message | Ernest E Vogelsinger | 2003-06-13 21:04:44 | Re: Postgres performance comments from a MySQL user |