From: | "Maksim Likharev" <mlikharev(at)aurigin(dot)com> |
---|---|
To: | "Dann Corbit" <DCorbit(at)connx(dot)com>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: return records in DB load order?? |
Date: | 2003-06-13 20:44:19 |
Message-ID: | 56510AAEF435D240958D1CE8C6B1770A014A0C79@mailc03.aurigin.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)connx(dot)com]
Sent: Friday, June 13, 2003 1:37 PM
To: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] return records in DB load order??
> -----Original Message-----
> From: Maksim Likharev [mailto:mlikharev(at)aurigin(dot)com]
> Sent: Friday, June 13, 2003 1:33 PM
> To: gearond(at)cvc(dot)net
> Cc: pgsql-general(at)postgresql(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | weigelt | 2003-06-13 20:48:53 | Re: return records in DB load order?? |
Previous Message | scott.marlowe | 2003-06-13 20:40:07 | Re: viewing the original order of entered records |