Re: return records in DB load order??

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

Browse pgsql-general by date

  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