Re: return records in DB load order??

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

Browse pgsql-general by date

  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