Re: return records in DB load order?? - Mailing list pgsql-general

From Maksim Likharev
Subject Re: return records in DB load order??
Date
Msg-id 56510AAEF435D240958D1CE8C6B1770A014A0C79@mailc03.aurigin.com
Whole thread Raw
In response to return records in DB load order??  ("Maksim Likharev" <mlikharev@aurigin.com>)
List pgsql-general
I am pretty much understand what going to happen with int4 when it hit
2^32 + 1,
but what going to happen with PostgreSQL and that that particular
table if all rows are alive?


-----Original Message-----
From: Dann Corbit [mailto:DCorbit@connx.com]
Sent: Friday, June 13, 2003 1:37 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] return records in DB load order??


> -----Original Message-----
> From: Maksim Likharev [mailto:mlikharev@aurigin.com]
> Sent: Friday, June 13, 2003 1:33 PM
> To: gearond@cvc.net
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] return records in DB load order??
>
>
> Is isn't suppose to be unique?

What happens when you have 2^32 + 1 rows in a table?  A 4 byte OID
cannot contain it.

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

pgsql-general by date:

Previous
From: weigelt@metux.de
Date:
Subject: Re: using sequences
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] SAP and MySQL ... [and Benchmark]