Re: return records in DB load order??

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